Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what's going on with SELECT INTO in PL/SQL?

Re: what's going on with SELECT INTO in PL/SQL?

From: <tedchyn_at_yahoo.com>
Date: Thu, 19 Aug 1999 17:57:48 GMT
Message-ID: <7phgi0$7rr$1@nnrp1.deja.com>


In article <37be15e7.589304444_at_news.supernews.com>,   soybean_at_hushmail.com (soybean) wrote:
> I am working on a trigger that needs to do a select from a different
> table then the one that the trigger functions on. But I can't really
> figure out how to deal with the case where the select returns no rows,
> which is acceptable.
>
> I wrote this function to try to test the functionality of selects in
> pl/sql, but it's not helping much. The first thing that I can't figure
> out is why this function returns 'hello' if both selects succeed
> otherwise it returns nothing. How do I check for the success of the
> select? Why does it ever return nothing? what is s_isbn after a failed
> select into?
>
> CREATE OR REPLACE FUNCTION select_test (
> in_isbn_id number)
> RETURN VARCHAR2 iS
>
> l_isbn DBO.ISBN%ROWTYPE;
> s_isbn DBO.ISBN_STAGE%ROWTYPE;
> BEGIN
>
> SELECT *
> INTO l_isbn
> FROM DBO.ISBN
> WHERE ISBN_ID=in_isbn_id;
>
> SELECT *
> INTO s_isbn
> FROM DBO.ISBN_STAGE
> WHERE ISBN_ID=in_isbn_id;
>
> RETURN 'hello';
>
> END select_test;
> /
>
> I'd appreciate any insight anyone can offer me.
> Thanks
> Soy
>

soy, you need if condition in the code. ted chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 12:57:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US