I am trying to use the sql RETURNING clause .
I have a sequence item product_seq defined . When I try to the following:
my $sth = $dbh->prepare( $sql_cmd ); $sth->bind_param_inout(1,\$product_id, 5); $sth->execute();
I get :
Database error: ORA-00439: feature not enabled: RETURNING clause from this client type (DBD: oexec error)
insert into tools ( product_name, product_id, vendor_id, category,support_contact_id,license_contact_id,
....
) values ('PC Pricing', product_seq.nextval,
....
) returning product_id into ?
Can't bind unknown placeholder ':p1' (1) at insert_data.pl line 231, <Tools> line 672
Don Leslie
_______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm
