AppletTalk.com Forum Index AppletTalk.com
Java discussions newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Oracle, JDBC and Clob as IN parameter of stored procedure

 
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases
View previous topic :: View next topic  
Author Message
karol
Guest





PostPosted: Sat Jul 19, 2003 5:38 pm    Post subject: Oracle, JDBC and Clob as IN parameter of stored procedure Reply with quote



Hi guys,
I hava a problem: I would like to call Oracle stored procedure with clob
parameter (IN), but my code creating clob object with some data throws
exceptions. Could You show me some code creating Oracle clob object with
some data (taken from string object), which then will be pass as a parameter
of stored procedure to CallableStatement and will work;) PLEASE.


Back to top
kk
Guest





PostPosted: Sat Jul 19, 2003 6:36 pm    Post subject: Re: Oracle, JDBC and Clob as IN parameter of stored procedur Reply with quote




U¿ytkownik "karol" <karol (AT) procontrol (DOT) piap.waw.pl> napisa³ w wiadomo¶ci
news:bfbv54$kot$1 (AT) news (DOT) onet.pl...
Quote:
Hi guys,
I hava a problem: I would like to call Oracle stored procedure with clob
parameter (IN), but my code creating clob object with some data throws
exceptions. Could You show me some code creating Oracle clob object with
some data (taken from string object), which then will be pass as a
parameter
of stored procedure to CallableStatement and will work;) PLEASE.

I have found some interesting article at
http://technet.oracle.com/sample_code/tech/java/codesnippet/jdbc/lob/LobToSP
..html



Back to top
Display posts from previous:   
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.