Re: runtime tablenames in stored procedure.

From: Phil Preen <obiwan-preen_at_maytheforcebewithyou.co.uk>
Date: Tue, 18 Jan 2000 11:14:57 -0000
Message-ID: <948194274.28607@red.parallax.co.uk>

<kagopi_at_my-deja.com> wrote in message news:8606p2$156$1_at_nnrp1.deja.com...
> Hi all,
>
> Is there a way to provide the table names to a stored
> procedure at runtime.. ?
>

You will need to use dynamic SQL. Look-up DBMS_SQL in your Oracle books. Received on Tue Jan 18 2000 - 05:14:57 CST

This message: [ Message body ]
Next message: Phil Preen: "Re: Drop column from a table"
Previous message: Phil Preen: "Re: Convert Excel Spreadsheet to SQL Script??"
In reply to: kagopi_at_my-deja.com: "runtime tablenames in stored procedure."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US