Re: Question on How to call a Select stmt in a Stored Procedure ?
From: Rev Dr Phil Herring <revdoc_at_wumpus.cc.uow.edu.au>
Date: 13 Sep 1994 00:58:32 GMT
Message-ID: <352tfo$9ma_at_wabbit.cc.uow.edu.au>
Date: 13 Sep 1994 00:58:32 GMT
Message-ID: <352tfo$9ma_at_wabbit.cc.uow.edu.au>
In article <34niog$559_at_bcarh8ab.bnr.ca> Karla Dods, sticklan_at_bnr.ca writes:
>I am trying to execute a stored procedure which contains a select from
>within an OCI C program. I can't find any examples and my program is
>failing with an ORA-6502 PL/SQL numeric or value error.
>
>Any examples or assistance will be greatly appreciated.
>I'm stuck on this error message.
Wrap the procedure call in an anymous PL/SQL block.
- Phil.
(c) 1994 Rev. Dr. Phil Herring revdoc_at_wumpus.cc.uow.edu.au- Church of the Sacred Dial Tone, Wollongong, Australia -
Permission is hereby granted to: 1. quote the original material in this
article when posting responses to it via Usenet or when sending responses
to myself or others via electronic mail; and 2. copy the entire article
intact via Usenet for the purposes of transmitting the article to other
Usenet sites. All other reproduction of this article constitutes a breach
of copyright laws and will be subject to both civil and criminal action.
- Church of the Sacred Dial Tone, Wollongong, Australia -
Permission is hereby granted to: 1. quote the original material in this
article when posting responses to it via Usenet or when sending responses
to myself or others via electronic mail; and 2. copy the entire article
intact via Usenet for the purposes of transmitting the article to other
Usenet sites. All other reproduction of this article constitutes a breach
of copyright laws and will be subject to both civil and criminal action.