| URGENT!!! HELP ME Please ... UNABLE to Insert into ORACLE [message #93586] |
Thu, 11 July 2002 01:34  |
sofian wijaya
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Is This how you insert into Oracle using Pro*C?
I am unable to insert this into my database ... very frustrated ... have checked all possibilities that I can think of ... datatype is correct ...
EXEC SQL
INSERT INTO met_sltpmgww
(
session_number,
po_rcv_number,
org_lvl_child,
org_lvl_number,
tag_indicator,
tran_type,
ticket_source,
prd_lvl_child,
prd_lvl_number,
prd_sub_class,
vendor_number,
vpc_case_pack_id,
slt_qty_desired,
prd_sll_uom,
prd_lvl_parent,
prd_lvl_parent_id,
curr_code,
last_pis_date
)
VALUES
(
:gi_session_num,
:gi_document_num,
:gi_org_lvl_child,
:gi_org_lvl_number,
:gca_tag_indicator,
:gca_tran_type,
:gi_ticket_source,
:gi_prd_lvl_child,
:gca_prd_lvl_number,
:gca_prd_sub_class,
:gca_vendor_number,
:gca_vpc_case_pack_id,
:gd_slt_qty_desired,
:gca_prd_sll_uom,
:gi_prd_lvl_parent,
:gi_prd_lvl_parent_id,
:gca_curr_code,
:gca_last_pis_date);
EXEC SQL
COMMIT WORK;
|
|
|
|
| Re: URGENT!!! HELP ME Please ... UNABLE to Insert into ORACLE [message #93587 is a reply to message #93586] |
Thu, 11 July 2002 08:02  |
Nina
Messages: 113
Registered: March 2000
|
Senior Member |
|
|
1) do you get an error message if so then which?
2) I looked at our Pro*C's looks the same, the only thing is that I do not see u including the reference to the SQL Communication Area or did you just not include in your portion of code..you probably did?
EXEC SQL INCLUDE SQLCA
3)Can you flag your :variables through the program?
Before you do an insert, do printf of :gi_session_num and the rest of ur variables.
4) Is the table that you are trying to insert to in your own schema and do you have insert privileges?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
