HOW to get the bind variables list.

Posted on 16th Feb 2014 07:03 pm by admin

I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need to use DBMS_SQL in order to execute them.
In theese SQL statements I have some bind variables like :NUMORD. (ex. SELECT 'X' FROM YYYY WHERE FIELD_1 = :NUMORD).
I don't know "a priori" names and number of such variables.
Is there any way to have a list of such bind variables ?
I found DBMS_DESCRIBE but is seems to act only on stored procedures/functions.
I know I can tray to inspect the code looking for every ':' but a cleaner solution woulf be appreciated.
Tks

Your Answer:

Login to answer

Other forums

onclick problem
I have <input type="text" name="message">
<a href=page2.

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

Sub-domains & calling unique content
Hello,

Is there a way use something similar to the $_GET function for a sub-domain? I to be a

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

$_POST
Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo