Home » SQL & PL/SQL » SQL & PL/SQL » Re: How to Retrieve CLOB withADODB Command Parameter...?
Re: How to Retrieve CLOB withADODB Command Parameter...? [message #36432] Tue, 27 November 2001 12:49
Tim
Messages: 49
Registered: October 2000
Member
My coworker and I have been exploring XML out of the database through clobs for the last couple of days, and yesterday ran into this problem, and we have finally (two minutes ago) found a way around it. For us, our problem was comming from a synonym. If you are using a synonym, call the procedure directly and see if that works. I assume that there is an issue with the Oracle provided when using synonyms. Also, we havent tried it using adCmdText, we use adStoredProcedure then just name the procedure in the CommandText, so if you make the change and it still doesnt work, try that. I hope that helps.

----------------------------------------------------------------------
Previous Topic: Ref Cursor Exception
Next Topic: Re: use variable in SQL statement
Goto Forum:
  


Current Time: Thu Mar 28 23:54:13 CDT 2024