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

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and

sendmail code suddenly not working
Hi Guys, I maintain 3 sites (including my own) I use the following code from a french webmaster that

Inserting a check in checkbox from array value
Hello all,
I have a bit of code that works for a select option box, but does not work for my chec

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<