Re: DBMS_SQl.Parse problem

In article <7lvc09$9l8$1_at_nnrp1.deja.com>, bellintani_at_my-deja.com writes
>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.

It would be useful if you could include the procedure that is causing the problem...

Andy
--
Andy Hardy. PGP key available on request