Hi

is there any equivalent of SQL-DMO for Oracle? I'd like to be able to
enumerate, create objects like triggers on Oracle using JAVA. Shall I
just use JDBC thin driver? what are your opinions?

thanks

greets
schw

Hi,

You can use the odbc thin driver to connect the oracle datbase. You can
create the oracle objects in oracle and the same objects you can create
in java and pass the same java object to oracle functions or
procedures.

You have insert program in java for emp object. In oracle create the
insert_emp function and pass the java object(same as in oracle object)
as a IN parameter to insert the java object values into oracle table.


The Oracle function is :

FUNCTION create_company(
o_company IN company_model,
p_company_id OUT thr_company.company_id%TYPE)
RETURN NUMBER
IS
BEGIN


INSERT INTO thr_company (
company_id,
company_name,
company_type,
address1,
address2,
city,
state,
zip,
url1,
url2,
url3,
phone,
fax,
link_elsewhere,
ticker_symbol,
company_logo,
status,
hcd_id,
thr_company_id,
country,
primary_id,
secondary_id,
primary_label,
secondary_label,
created_date)
VALUES(
p_company_id,
o_company.company_name,
o_company.company_type,
o_company.address1,
o_company.address2,
o_company.city,
o_company.state,
o_company.zip,
o_company.url1,
o_company.url2,
o_company.url3,
o_company.phone,
o_company.fax,
o_company.link_elsewhere,
o_company.ticker_symbol,
o_company.company_logo,
o_company.status,
o_company.hcd_id,
o_company.thr_company_id,
o_company.country,
o_company.primary_id,
o_company.secondary_id,
o_company.primary_label,
o_company.secondary_label,
SYSDATE);

COMMIT;

v_sql_identifier := 'SQL Section 2';
RETURN v_retval;
EXCEPTION
WHEN OTHERS
THEN
RAISE_APPLICATION_ERROR(-20001,SQLCODE || SQLERRM);
RETURN 1;
END;

Thanks,

Mohan Reddy G

schw wrote:
> Hi
>
> is there any equivalent of SQL-DMO for Oracle? I'd like to be able to
> enumerate, create objects like triggers on Oracle using JAVA. Shall I
> just use JDBC thin driver? what are your opinions?
>
> thanks
>
> greets
> schw