Board index » delphi » Oracle - Stored Procedure - Output Params - Delphi

Vijay

Delphi Developer
Tue, 08 Jun 2004 22:43:09 GMT

Oracle - Stored Procedure - Output Params - Delphi

Hi,
I want to return a output parameter of oracle stored procedure to delphi
front end.  The output parameter will have more than 1000 character..  So I
have declared as 'Long' the output parameter..  While accessing the output
parameter from delphi, raises error like 'Capability not supported' or
'Unknown Datatype'.  I have used param datatype in Delphi are 'ftMemo',
'ftWideString', 'ftString'...

Please anyone give solution for this... If you give, it is really helpful
for me..

Thanks
Vijay

 
Robert Cern

Delphi Developer
Wed, 09 Jun 2004 03:27:46 GMT

Re:Oracle - Stored Procedure - Output Params - Delphi


AFAIK, char output parameters are limited to length 255. Use result set
instead.

--
Robert

Quote
Vijay wrote in message <3c234812_2@dnews>...
>Hi,
>I want to return a output parameter of oracle stored procedure to delphi
>front end.  The output parameter will have more than 1000 character..  So I
>have declared as 'Long' the output parameter..  While accessing the output
>parameter from delphi, raises error like 'Capability not supported' or
>'Unknown Datatype'.  I have used param datatype in Delphi are 'ftMemo',
>'ftWideString', 'ftString'...

>Please anyone give solution for this... If you give, it is really helpful
>for me..

>Thanks
>Vijay

Other Threads

1. OUTPUT Params from Stored Procedures HELP MS SQL Server

2. Additional Information for Posting on No Output Params on Stored Procedure

3. Problem with ADO and Output Params of Stored Procedures

4. Output params not being set in stored procedure

5. BLOB as output parameter in Oracle stored procedure?

6. Output parameter of stored procedure with Oracle are always empty

7. Using dbExpress Stored Procedure Component and Oracle 9i Stored Procedure

8. Output parameter of a Stored Procedure problem with Sybase and Delphi 5

9. Problem with Output Params in MS SQL 7 Stored Procs

10. Stored proc and output params