Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Location
    Mumbai (India)
    Posts
    11

    Unanswered: Temprary table in procedure

    Hi,

    DATABASE: ORACLE 10

    I want to create global temporary table in procedure but it is throwing error
    PLS:00103 Encountered the symbol "CREATE" when expecting one of ...

    I think it is DDL statement and thatswhy it is not working.

    Then what is the solution?

    Is it possible to create table with
    INSERT INTO TEMP_TAB1
    SELECT * FROM ..

    Please convey me asap.

    Thanks,

    Vikrant Patil

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12

Posting Permissions

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