Re: ORACLE AND FUNCTIONS

Article View: borland.public.cppbuilder.database.ado

Article #4853

Back to borland.public.cppbuilder.database.ado Previous Next

#4853

From: BM
Date: Tue, 18 Sep 2001 19:46

26 lines
1644 bytes

1) First of all can you run any sps at all (i.e. create another one with a
simple return type i.e. Varchar2. )?  From your error message it sounds like
its not identifying the sp in the first place.
2) Are you prefixing your function with the schema name?

BM


"ALBERTO GUERRA" <alberto271779@hotmail.com> wrote in message
news:3b9d939a_1@dnews...
> HI,
>
> I have C++ BUILDER 5 ENTERPRISE, I'm working with ORACLE 8.1.7, and i have
a
> ORACLE FUNCTION what return a CURSOR REF.
>
> I�m trying to call this function using ADO STORED PROCEDURES but i get the
> following error:
>
> ORA-06550: line1, column 7:
> PLS-00221: 'GETE' is not a procedure or is undefined
> PL/SQL: Statement ignored.
>
> How I can call a ORACLE FUNCTION and get a CURSOR inside BCB?
>
>

Technical Details

Message-ID: <3ba7abf6_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3b9d939a_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,a42028afb32469f8
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-09-18 13:40:48 PST
From: "BM" <m02x7z00@cwcom.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b9d939a_1@dnews>
Subject: Re: ORACLE AND FUNCTIONS
Date: Tue, 18 Sep 2001 20:46:01 +0100
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 212.137.169.71
Message-ID: <3ba7abf6_1@dnews>
X-Trace: dnews 1000844278 212.137.169.71 (18 Sep 2001 13:17:58 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message