Xref: alice comp.databases.oracle.misc:35508
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: bellintani@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: DBMS_SQl.Parse problem
Date: Wed, 07 Jul 1999 11:02:35 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 28
Message-ID: <7lvc48$9lp$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Jul 07 11:02:35 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; I)
X-Http-Proxy: 1.0 x35.deja.com:80 (Squid/1.1.22) for client 193.120.20.58

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@phoenix.ie


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.