Bye, Chris.
Thank you, but nothing work.
1. The orafce from www.pgfoundry.org doesn't pass the make step, is
looking for some files that doesn't exist, see below:
orafce : make
Makefile:16: ../../src/Makefile.global: No such file or directory
Makefile:17: /contrib/contrib-global.mk: No such file or directory
make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.
It is designed to be built from the postgresql source tree. If you have
a postgresql source tree put the orafce directory in contrib and try again.
Sincerely,
Joshua D. Drake
2. ora2pg, looks like something that extract DB schemes from a running
oracle DB, but I have not ORACLE running. I just have old ORACLE/SQL
sources that I need parser to SQL or PostgSQL.
3. About the ambitious project "protopg", I success to compile this
projects but the parser fall. The parse have a problem with a word
"CONSTRAINT", see below:
protopg-20060905 : ./ora_parser < tes.sql
-- syntax error, unexpected "CONSTRAINT", expecting ORA_ID on line 6 --
-- BEGIN OF UNRECOGNIZED STATEMENT
CREATE TABLE v5templates . cmt_items ( item_id NUMBER ( 7 ) ,
template_id NUMBER ( 7 ) , page_title VARCHAR2 ( 100 ) , CONSTRAINT
pk_cmt PRIMARY KEY ( item_id ) ) ;
-- END OF UNRECOGNIZED STATEMENT
I will try debug it, or maybe send a mail to the developer/contacts.
Any way, thank very much, Gustavo
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
