how to pass a list or long string from Oracle stored proc to TStoredProc in Borland

kro...@cbot.com

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

how to pass a list or long string from Oracle stored proc to TStoredProc in Borland

Hi,

Can anyone tell me how I can pass a long string from an Oracle stored proc to
a Builder TSToredProc? What data types should I use on either side? Maybe
blob on Borland side and RAW on Oracle? This is not documented anywhere in
Borland. By a "long string" I mean up to 10,000 bytes.

Thank you,
Ken Ross

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

Other Threads

1. passing back a 2nd parameter from Oracle stored procedure to TStoredProc

2. Problem in returning long string from Oracle Store Procedure

3. storing and loading long strings with a stored procedure cuts after 255 chars

4. *** Using dataset returnet by a stored proc inside another stored proc ***

5. Passing string parameters to a TStoredProc

6. Does TStoredProc truncate strings longer than 255 characters ?

7. Pass arrary as parameter to Oracle Stored Procedure and get back Oracle cursor

8. Please help -- Stored Proc parameter passing.

9. Passing SQL 7 GUID fields to stored proc and tables in Delphi

10. Passing NULLs in a DBXpress Stored Proc