Good morning all,
I joined the list yesterday, and need help with this problem:
I have been using Oracle PL/SQL for several years. I have been
teaching myself Perl over the last 6-12 months.
When writing a procedure in Oracle PL/SQL, variables can be defined
with types that are relative to columns types within the database,
itself. This allows database developers to write procedural code
generically, that will "self-adapt" to any future changes in the
database column field lengths and field types.
This method of defining relative variable types is a defacto
standard where I work because of development and other legacy
issues, though regular types (Integer, Boolean, etc.) are used
when necessary.
#Example:
#
# PROCEDURE do_nothing(var1 IN number, var2 IN VARCHAR2) IS
#
# -- Variables
# v_name table_synonym.name%TYPE;
# v_address table_synonym.address%TYPE;
# v_details table_synonym.details%TYPE;
#
#
# ...(rest of code)
#
# END do_nothing;
I will be creating temporary tables, and need to be able to
manipulate the Perl variables within Perl locally, and have them defined
relative to certain columns.
Q1: Does Perl have a means by which a Perl-variable can be created
based on an Oracle database column type?
Q2: If so, could you teach me the proper syntax, or direct me to
the proper documentation?
Q3: If not, what are your suggestions for alternative approaches?
Q4: Can the do{} statement (or some other command) be used as a
wrapper around an entire PL/SQL procedure, thus allowing me
to wrap an existing PL/SQL procedure and have it work properly?
Thank you for your time and help,
Bob
[EMAIL PROTECTED]
