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

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

Problem with DB connection
Hello there! I'm new to this forum and I'm new to PHP coding also. I wrote something that doesn't ma

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Preg_match unknown modifyer
Hello,

Im trying to write a little script for my forums i need to get the reply from my forum

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if