Re: Execute a stored procedure from OCI

Thanks..Can you post your procedure code?

"Rolf C Stadheim" <r-stadhe_at_online.no> wrote:

>The error messages were (translated from my locale to English):
>
>For 'EXECUTE INSERT_ROOM(45)' and 'EXEC SQL INSERT_ROOM(45)':
>ORA-00900 INVALID SQL STATEMENT
>
>For 'BEGIN INSERT_ROOM(45) END;':
>ORA-06550: ERROR LINE 1 CHAR -- PLS-00103: END OCCURRED WHERE ONE OF THE
>FOLLOWING WERE EXPECTED:
>:= . ( % ;
>
>For 'BEGIN INSERT_ROOM(45);':
>ORA-06550 :
>
>Regards,
>Rolf
>
>"TurkBear" <jgreco1_at_mn.rr.com> skrev i melding
>news:r7pb3u8c3a3rpfdmpjsjjnt2l2j7g4m7t2_at_4ax.com...
>>
>> Please list the varying error messages..
>> meanwhile,
>> Check:
>> Are you logged in as the owner of the procedure?
>> If not, use the fully qualified name SCHEMAOWNER.INSERT_ROOM(), assuming
>you have permission to use it, and to insert into
>> the table
>> the syntax ( if room is a NUMBER ) is EXEC INSERT_ROOM(45)
>>
>>
>> "Rolf C Stadheim" <r-stadhe_at_online.no> wrote:
>>
>> >How can I execute a stored procedure (a non-select procedure that inserts
>a
>> >row) from an OCI C-routine?
>> >
>> >I have tried
>> >
>> >'EXECUTE INSERT_ROOM(45)',
>> >'EXEC SQL INSERT_ROOM(45)',
>> >'BEGIN INSERT_ROOM(45) END;',
>> >'BEGIN INSERT_ROOM(45);'
>> >
>> >but all fails with varying error-messages.
>> >
>> >I'm using the Oracle 7.3 OCI libraries.
>> >
>> >RCS
>> >
>>
>>
>>
>> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>> Check out our new Unlimited Server. No Download or Time Limits!
>> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Jan 07 2002 - 13:18:25 CST