[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
OpenLDAP+Oracle10g
Hello
I'm testing with OpenLDAP+Oracle10g.
When I wrote the sql like below:
CREATE OR REPLACE FUNCTION create_person RETURN number AS
keyval number;
BEGIN
INSERT INTO persons (id,name) VALUES (person_ids.nextval,' ');
select max(id) into keyval from persons;
RETURN keyval;
END;
/
insert into ldap_oc_mappings (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
values (1,'inetOrgPerson','persons','id','create_person()','delete_person(?)',0);
Or
insert into ldap_oc_mappings (id,name,keytbl,keycol,create_proc,delete_proc,expect_return)
values (1,'inetOrgPerson','persons','id','exec :keyval:=create_person()','delete_person(?)',0);
Or
insert other values which can be run without problem by sql*plus to
ldap_oc_mappings.create_proc.
If I run ldapadd, ORACLE server returns a same error for every value.
--------
backsql_add("cn=test,o=sql,c=ru"): create_proc execution failed
Return code: -1
Native error code: 900
SQL engine state: 51
Message: [unixODBC][DataDirect][ODBC 20101 driver][20101]ORA-00900: invalid SQL statement
Does anyone know this? Help me please.
Best regards
Pu