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

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output in PROC

Re: dbms_output in PROC

From: Laurent Kloetzer <charles.magne.non.au.spam_at_kloetzer.fr.st>
Date: Thu, 27 Apr 2006 10:57:52 +0200
Message-ID: <mn.da917d643099cd14.36141@kloetzer.fr.st>


OK, I found the solution.
The problem is that i'm triying to fetch a NULL value into my "line" variable.
I used a user defined "get_lines" that does never return any NULL value to solve this.
I think there is a prettier solution using indicator variables, but I do not fully understand yet how they work. If someone has an idea...

Laurent Received on Thu Apr 27 2006 - 03:57:52 CDT

Original text of this message

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