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

Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

Checking if a process is running (problems including psapi.dll i think...)
Ok, so all I'm trying to do is check if a program is running...

I've found out that I nee

Variables and Include
Code: [Select]<?php

$header = $_COOKIE['mss']['header'];
$body = $_COOKIE['mss']['b

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

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

turning an array into a string then poping it into a db
Hi im just wondering how you get a requested array into a single string then pop it into the db so f