Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question regarding LOB
Thanks a lot for your help.
Dave, a further question. In my program, i plainly invoke a stored procedure on the database which does the job of inserting the LOB, thereby shielding my application from SQL completely.
BEGIN insert_to_database(:lob_var) END;
Do i still need to execute a select statement to fetch the Lob Locator? In other words, if i just do a OCIDescriptorAlloc followed by OCIBindByName and OCIStmtExecute(which actually invokes the stored procedure), will it suffice? If so, does it pose any additional requirements on the stored procedure??
Thanks and Regards,
Shankar
shanky191_at_rediffmail.com (Shankar) wrote in message news:<24707dc9.0311101903.3ded3065_at_posting.google.com>...
> I intend to write a BLOB to database by binding a variable of type
> OCILobLocator through OCIBindByName and then OCIExecuteStmt....I get
> this data from another module as a character array. How do i copy the
> contents of the array into my OCILobLocator?
>
> char buff[MAXSIZE]; ---> contains the data i wish to write (MAXSIZE is
> HUGE!)
> OCILobLocator *lob_ptr;
>
> Now to copy buff to lob_ptr????
Received on Tue Nov 11 2003 - 21:54:06 CST