Hello, 2009/9/17 Arnold, Sandra <ArnoldS@xxxxxxxx>: > We are in the process of migrating from Oracle to PostgreSQL. One of the > things that we are needing to find out is what to use in place of Oracle > supplied functionality such as "DBMS_OUTPUT" and "UTL_FILE". We are > currently using this type of functionality in Stored Procedures and > packages. What are the options in PostgreSQL for replacing these two > packages in a stored procedure/function? > Thanks, > - for typical use you can use RAISE NOTICE without DBMS_OUTPUT, UTL_FILE isn't supported by core. Migration process could be simplified by using Orafce package: http://pgfoundry.org/projects/orafce/ http://orafce.projects.postgresql.org/ regards Pavel Stehule > Sandra Arnold > Sr. DBA > DOE/OSTI > Oak Ridge, TN -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general