Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: Executing truncate in store proc (toad)

    my requirement is very simple I need to truncate some tables in test and get the data for those tables from the production.

    But store proc was not allowing me to use truncate directly but I got the solution for that, I used execute immediate 'truncate table' || tablename

    But when am trying to execute the procedure with execute procedure, it is not executing instead it is giving error ORA codes 903 and 6512 but I believe it is more than this, Can somebody tell how to get the procedure executed when we give multiple tables using execute immediate.

  2. #2
    Join Date
    Sep 2010
    Posts
    2

    addition to the aove question

    ORA-20001: AN ERROR ENCOUNTERED - -903 -ERROR- AN ERROR ENCOUNTERED - -903 -ERROR- ORA-00903: invalid table name
    ORA-06512: at "SEDWLND. procedure name", line 382
    ORA-06512: at line 175

    this is the error which am getting

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    ORA.....

    Are you on the right forum?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •