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: Oracle Webserver 2.1-Stored Procedure Calls from a Cartridge written with RogueWave DBTools.h++

Re: Oracle Webserver 2.1-Stored Procedure Calls from a Cartridge written with RogueWave DBTools.h++

From: Oracle-Owner <oracle_at_odin.fli.sh.bosch.de>
Date: 1997/03/06
Message-ID: <331EB10D.1D21@odin.fli.sh.bosch.de>#1/1

> ----------------------------------------------------------------------
> FUNCTION userTypeSelectOptions RETURN VARCHAR2 IS
> CURSOR userTypeC IS
> SELECT userTypeID, userType FROM userType;
> stro VARCHAR2(1000) := ''; -- Line 81
> BEGIN
There are no empty strings in PL/SQL. Maybe you should try to initialize the variable stro with NULL instead:

stro VARCHAR2(1000) := NULL;

Maybe this is causing problems in some PL/SQL Execution Environments.

Hope, this helps Received on Thu Mar 06 1997 - 00:00:00 CST

Original text of this message

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