Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2009
    Posts
    46

    Unanswered: Create Temporary Table in Stored Procedure

    Hi,

    I want to Create Temporary Table in side the stored procedure but it is giving error.

    tell whate is the process to create Temporary Table in Stored Procedure.

    Regard's
    Prasad!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I want to Create Temporary Table in side the stored procedure but it is giving error.

    Good for Oracle.
    Oracle is not MSQL or SQLServer.
    You do not need temporary table.

    What problem are you really trying to solve?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, just like Anacedent has already said, you probably really do NOT want to create any kind of a table in PL/SQL. However, for your information, you'd do such a thing with some help of dynamic SQL (search for EXECUTE IMMEDIATE).

  4. #4
    Join Date
    Jun 2009
    Posts
    46
    Hi,

    Actualy i am new for oracle,
    And I am converting application from sqlserver to Oracle.
    I have used temporary tables in side the Sql Stored Procedure.
    now i am not able to create those temp table in oracle.
    can you suggest me how i can handle this issue or is there any other way to create temporary tables in oracle.

    Regard's
    Prasad

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    In most cases, Oracle is capable of doing it all WITHOUT temporary tables.

    What would you put in there, anyway? If you are new to Oracle, I guess it is difficult to think differently all of the sudden, but you'll have to study Oracle a little bit; otherwise, you'll produce an application which might be much worse than the current one.

  6. #6
    Join Date
    Feb 2009
    Posts
    62
    The main thing that Sql Server uses temporary tables for is to hold results of small queries, to allow them to be combined into larger queries.

    Oracle handles large / complex queries much better, and you don't need to split your queries down.

Posting Permissions

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