Dynaminc PL/SQL problem.

I've trying to write a procedure that to impose different naming conventions for object creation in my database. The intention was to accept the inputs into my procedure, use these to select the name of the correct convention to use from a table, and use the correct convention procedure name and the input parameters in a dynamic PL/SQL statement.

eg.

v_TSCNstmt := 'BEGIN
PKGTimeSlotCustomNaming.'||temp||'(:o_TSCN_ErrorCode,:o_TSCN_ErrorText,:o_name,:i_TimeSlotNumber,:i_CircuitBandwidth,:i_CircuitDef); END; '; the temp value (naming convention procedure) is inserted fine, but I am having a trouble with the parameters for the Custom Naming Procedure. I've tried binding them - but this doesn't seem to do any good. If I remove the parameters it works fine - but is useless. Any help would be much appreciated, especially if it could be mailed to me along with the news post

thanks,

James Received on Thu May 24 2001 - 08:47:57 CDT