21st Century PL/SQL

June 30, 2005

UTL_FTP

For whatever reason, a number of my past projects have involved getting raw data from source systems/hardware using FTP. The programs are usually written in Java, some shell, or PERL. Lots of error handling, notification and controls are eventually added to handle network outages, incomplete files, and so on. The end goal, of course, has always been to eventually get the raw data into the database.

The problem is that we end up writing a mini-system around these programs, when we have already got error handling, notification and so on written in PL/SQL in the database that we would like to take advantage of.

If Oracle can write UTL_SMTP, UTL_FILE and so on, why not help us out with UTL_FTP, UTL_TELNET/SSH and other low-level and standard protocols for remote data push/pull? I would like to quit writing these from scratch every time I change jobs.

Posted by Bill Coulam at 06:17 PM | Add your thoughts (17)

July 21, 2005

modify debug.f to write to specified table

Provide built-in tracing support in PL/SQL. Can direct output to the desired "target", from file to table to pipe, etc.

Offer various ways to filter/enable tracing: by program name, by "level", by string filter.

Posted by Kathy Limbaugh/modified by Steven Feuerstein at 01:58 PM | Add your thoughts (8)

October 11, 2005

Get the name of the current procedure

Many of my package procedures start with code like declare l_procname := gs_packageName || \\\\\\\'.DemoProc\\\\\\\'; begin ... I would appreciate if it would be possible to have a way to initialize a variable to the current procedure name in a package. Some discussion on this is provided on [url=http://asktom.oracle.com/~tkyte/who_called_me/index.html] http://asktom.oracle.com/~tkyte/who_called_me/index.html [/url] however currently only the package name is provided. It would be very comfortable if SYS_CONTEXT(\\\\\\\'PLSQL\\\\\\\',\\\\\\\'PACKAGE_PROCEDURE\\\\\\\') would simply return the current name of the procedure (or function) in pl/sql.

Posted by Martin Strobl at 08:05 AM | Add your thoughts (66)