BorlandTalk.com

Arthur E.F.Heinrich · Guest

Hi,

I'm have an application writen in Delphi 5.0, using BDE, which uses an
Oracle database.
I'm trying to call the procedure DBMS_OUTPUT.GET_LINE to retrieve database
messages.

DBMS_OUTPUT is an Oracle package, not the owner of procedure GET_LINE.

When I set the ProcedureName in TStoredProc, an error like 'Procedure not
found' occur.

Using a TQuery there is no such problem, but this procedure expect two
parameters.
I'm executing the following statement:

begin
dbms_output.get_line(:line, :status);
end;

using two output parameters: :line - String, :status - Integer

When I call TQuery.ExecSQL, the parameters return blank strings using
AsString property.
The parameter :status should return 0 (zero) for an existent line and 1 for
no more lines. But it is not working.

What I'm doing wrong?
Is there another way to retrieve parameters used inside a PL/SQL block?

TIA
Arthur

Eric Hill · Guest

Arthur E.F.Heinrich · Guest

I'm using BDE since 97. But I created a software layer to simplify the
implementation and I can change my layer to use another connection layer.
It's easy.

I work with Oracle versions 8i and 9i and I know how to use get_line inside
a PL/SQL block. My problem is to retrieve data from output parameters in
TQuery. May be it's a limitation of BDE.

I frequently avoid using third party components, because I like to have
total control over my application. But I will think about that.

[]s
Arthur

"Eric Hill" <eric (AT) ijack (DOT) net> wrote in message
news:op.s5ott9lhsqk0wa@wcerich-6223.pioneer.world...

Eric Hill · Guest

Arthur E.F.Heinrich · Guest

I solved the problem using TStoredProc.

When I tried for the first time I was informing the proc name
dbms_output.get_line.
There exists a synonym for this object and I think it whould be respected,
but not. The message said "object must be declared". I solved the problem
informing the full name SYS.DBMS_OUTPUT.GET_LINE and it works.

BDE can be limited, but some basic things should work. This makes me insist
a bit more.

Using TQuery I can't retrieve output parameters and I don't expect it works
anymore.
But I will continue to use BDE while it works.

Thanks for the help

[]s
Arthur

"Eric Hill" <eric (AT) ijack (DOT) net> wrote in message
news:op.s5o56mfqsqk0wa@wcerich-6223.pioneer.world...