My guess is that it should allocate 200 bytes. If however PL/SQL variables Dynamic Memory Allocation then probably some minimal as set by the PL/SQL Engine designers/programmers.
Aleem -----Original Message----- Sent: Wednesday, March 06, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Riddle me this Oracle riddle... Robert, If this was a test, and you know the answer, please tell us what it was and how you got it. (trade secrets need not be revealed, of course). I thought I knew one way to find it, but the dump command I want to use doesn't work on 9 !! Using rather crude methods, some tests I have just invented seem to indicate that the answer is 4,000 bytes. Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases | ||Riddle me this Batman..... || ||Assume Oracle9i... || ||assume you have a table thusly defined: || ||Table Name: TEST ||col_1 number ||col_2 varchar2(200) || ||And now a procedure defined thusly: || ||create or replace procedure blah_blah ||( p_in_one test.col_2%type ) || ||Now, here is the question, how much memory will p_in_one have |allocated to ||it within PL/SQL?? Is the answer: || ||a. 200 bytes ||b. 2000 bytes ||c. 4000 bytes ||d. It will be defined based on the size of the data actually being |passed ||into the parameter of the PL/SQL procedure ||e. None of the above. || ||I'm currious what your answers will be... ;-) || || ||Robert G. Freeman - Oracle8i OCP ||Oracle DBA Technical Lead ||CSX Midtier Database Administration || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
