Recent content by Stephen

function TMyPackage.my_func(Pjson: TLOBLocator): TLOBLocator; begin Result := TLOBLocator.Create(Session, otCLOB); ThreadAcquire; try GetQuery; OCPQuery.DeclareVariable('function_result', otCLOB); OCPQuery.SetComplexVariable('function_result', Result)...

I see lots of examples using Delphi but non for C++ Builder with the temporary LOB (CreateTemporary) calls. I don't even know if that's what I need to do.... I have an Oracle function inside a package: function my_func(pJSON in clob) returning clob is cRetval clob := empty_clob(); begin...

Hi Marco! I have an Oracle package with a function that returns a sys_refcursor of type tbl$customer. I retrieve the refcursor and process it within C++ Builder without issues. At no point do I close the cursor / TOracleDataSet. What I would like to do is then pass the cursor BACK to Oracle...

Thanks Marco :-) I reinstalled the 10g client and set the field above as stated, but still get: Initialization error Could not load "D:\oracle\product\10.2.0\client_1\bin\oci.dll" OCIDLL forced to D:\oracle\product\10.2.0\client_1\bin\oci.dll...

Bueller?.....Bueller?..... Bueller? I really could use some help on this is somebody has some ideas. I need to be coding but am unable to access the database. Thanks, Stephen

I had the 9i client on this machine and have since uninstalled it and reinstalled 10g. I am able to successfully run SQLPLUS and attach to my remote database. Notice the Help->Support output doesn't have any information about my TNSnames.ora file... even though it exists. When I run PL/SQL...

I'm trying to get the Package Wizard to work. There's no program to compile atm, it just will not resolve the host name when I attempt to attach to the database.

I tried that.... Builder will partially install in the C:\Program Files\... as well as C:\Program Files (x86)\....

I've installed C++ Builder 6.0 Enterprise Edition on my new computer using Windows XP Pro x64. The default directory is C:\Program Files (x86)\Borland\CBuilder6. When I install Direct Oracle Access (4.07) and then try to use the Package Wizard, I get "TNS: Could not resolve service name"...

Thanks for the reply Marco. I've been out of the office but I'll give it a try and report back to you. Thanks! Stephen

Sorry for the long post, I just want to give as much information as possible: I have a package in Oracle which locates a row based upon a unique ID and returns it as a record type. Here's some watered down code: ORACLE PACKAGE (Customer) DEFINITIONS: type t_rcd_customer is record (...