-
Problems in COMMIT
hi all,
i'm newbie in ORACLE
i'm using ProC
i've wrieeten a quiery to INSERT data into a table
its returning sqlca.sqlcode = 0
after that i'm executing EXEC SQL COMMIT
its returning sqlca.sqlcode = 0
but while using SQLPLUS to check whether that INSERT statement worked or not its showing noe rows selected
so am i forgetting anything
Thanks in advance
Abhay.
-
What's your SQL statement for INSERT in ProC?
-
Problem In COMMIT
Originally posted by dba1
What's your SQL statement for INSERT in ProC?
I'm using ORACLE 9i and working on SPARC machine.
My SQL INSERT statement is like this
EXEC SQL INSERT INTO Tooldtls (
toolid
,toolname
,toolcost
,MC_DELETE_FLAG
,Tooldtls_ver
,DM_LstUpdDt
,DM_classType
,DM_CreatedAuthor
,DM_UpdatedAuthor
,DM_CreatedTS
,DM_UpdatedTS
) VALUES (
:h_toolid_CR
,:h_toolname_CR:i_toolname_CR
,:h_toolcost_CR:i_toolcost_CR
,:h_MC_DELETE_FLAG_CR
,:h_Tooldtls_ver_CR
,TO_DATE(:h_DM_LstUpdDt_CR,'YYYYMMDD')
,:h_DM_classType_CR
,:h_DM_CreatedAuthor_CR
,:h_DM_UpdatedAuthor_CR
,TO_DATE(:h_DM_DateTime_CR,'YYYYMMDDHH24MISS')
,TO_DATE(:h_DM_DateTime_CR,'YYYYMMDDHH24MISS')
) ;
The host variables over here are getting populated properly.
Thanks in advance.
Abhay.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|