OraFAQ Forum: Server Administration » ProC Long and Table CLOB

Home » RDBMS Server » Server Administration » ProC Long and Table CLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ProC Long and Table CLOB [message #373448]

Tue, 17 April 2001 15:27

rks11
Messages: 1
Registered: April 2001

Junior Member

I have a data type CLOB in my DB table. Can a Pro*C program insert a LONG VARCHAR into it. The table description is as follows:

SQL> desc tp_edi_in_msg_t
Name Null? Type
----------------------------------------- -------- ----------------------------
LSR_KEY NOT NULL NUMBER(38)
MSG_TEXT LONG
STATUS VARCHAR2(22)
STATUS_DETAIL VARCHAR2(22)
STATUS_ERROR NUMBER(38)
TRANSACTION_SET_ID NOT NULL VARCHAR2(3)
TRANSMISSION_DATE NOT NULL DATE

And my Pro*C program is doing an insert into MSG_TEXT by using a LONG VARCHAR(560000). Is this OK or do I have to use OCIClobLocator and all that stuff? Can somebody please send a code snippet for using CLOB inserts in Pro*C.

Thanks in advance.

Report message to a moderator

Previous Topic:	Can anyone send me sqlplus from Oracle 8i??
Next Topic:	Many months in same query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:32:34 CST 2024