Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_SQl.Parse problem
On Wed, 07 Jul 1999 11:02:35 GMT, bellintani_at_my-deja.com wrote:
Can you supply the code for insert_data_test. That way we can review it and help you find the problem.
chris.
>I was wondering if someone could help me with a plsql problem,
>specifically DBMS_SQl.Parse. I have created a procedure that will be
>executed by a trigger to insert a row into a table on a different
>server. However the procedure compiles ok but it will not execute: I
>am receiving the following error code when I try to execute it from the
>SQL cmd prompt:
>
> SQL> execute insert_data_test('application', 'applicationid');
>begin insert_data_test('application', 'applicationid'); end;
>
>*
>ERROR at line 1:
>ORA-01008: not all variables bound
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 348
>ORA-06512: at "SYS.DBMS_SQL", line 141
>ORA-06512: at "PRODUCT_USER.INSERT_DATA_TEST", line 22
>ORA-06512: at line 1
>
>I have not bound any variable because I am only inserting rows into a
>table, what variables do I need to bind.
>
>I am using this in a multi server configuration environment on NT v4.
>
>Thanks for emailing your answers/ideas to bellintanip_at_phoenix.ie
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.