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: ORA-06571 HELP!! HELP!! HELP!! HELP!!

Re: ORA-06571 HELP!! HELP!! HELP!! HELP!!

From: Fred Hirschfeld <johndoe_at_microsoft.com>
Date: 1997/10/10
Message-ID: <61n7s6$69u$1@news.bc>#1/1

>>Hi All,
>>
>> I have a problem with a Function. I´m using a function that INSERT
>>records in a Table.
>>The function is in a Package, the function Return a NUMBER. When I
>>called this function from
>>an SQL expression, such as:
>> SELECT <function-name> FROM DUAL;
>>

The key to this is the function is in a package... We had a similar problem, and fixed it by making the packaged function a stand alone function and it then worked. I don't know why though... anyone care to enlighten us?

--
    Cheers Fred
----------------------------------------------------------------------------
-----------------
Fred Hirschfeld                                      Sierra Systems
Consultants Inc
fhirsch_at_rogers.wave.ca                          Vancouver, BC (604)688-1371

http://www.sierrasys.com/
Received on Fri Oct 10 1997 - 00:00:00 CDT

Original text of this message

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