OraFAQ Forum: Forms » Execute a Procedure Using EXEC

Home » Developer & Programmer » Forms » Execute a Procedure Using EXEC_SQL Package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Execute a Procedure Using EXEC_SQL Package [message #85380]

Mon, 21 June 2004 02:57

Inderjeet Singh
Messages: 13
Registered: April 2004

Junior Member

Hi All,
�I am using Forms 6i & Oracle 9i. I am trying to connect to 2 different Users/Databases, using EXEC_SQL package. Everything is going fine(Insert/Update all), but when I try to Execute a Procedure in one of the connections, it raises Error while Parsing. I have written like this:
curs := EXEC_SQL.OPEN_CURSOR(l_to_conn);
l_sql := 'EXECUTE test';
EXEC_SQL.PARSE(l_to_conn, curs, l_sql);
Parsing statement is raisng the Error: ORA-306500

Thanks in Advance

Report message to a moderator

Re: Execute a Procedure Using EXEC_SQL Package [message #85382 is a reply to message #85380]

Mon, 21 June 2004 03:12

Tak Tang
Messages: 142
Registered: May 2004

Senior Member

'EXECUTE' is SQL*Plus shorthand for 'BEGIN .. END;'

Try this :-

l_sql := 'BEGIN test; END;';

Tak

Report message to a moderator

Re: Execute a Procedure Using EXEC_SQL Package [message #86663 is a reply to message #85380]

Mon, 18 October 2004 01:59

naresh godwal
Messages: 1
Registered: October 2004

Junior Member

Hi All,
I am using Forms 6i & Oracle 8i.when I try to fetch the records with connection, it raises Error while Parsing. I have written like this:
EXEC_SQL.PARSE(connection_id, cursorID, sqlstr, exec_sql.V7);
EXEC_SQL.DEFINE_COLUMN(connection_id, cursorID, mcount,v_name,40);
nIgn := EXEC_SQL.EXECUTE(connection_id, cursorID);
EXEC_SQL.COLUMN_VALUE(connection_id,cursorID, mcount,v_name);
Parsing statement is raisng the Error: ORA-306500

Report message to a moderator

Re: Execute a Procedure Using EXEC_SQL Package [message #86851 is a reply to message #85380]

Wed, 10 November 2004 09:38

Antonia.
Messages: 2
Registered: November 2004

Junior Member

I have a same problem, do you tell me please how do you resolve it.

Thanks.

Report message to a moderator

Previous Topic:	problem in running forms 9i
Next Topic:	problems with webutil.alternative solution?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:37:31 CDT 2024