Clearly the best guess is (e) - none of the above. It is unlikely to be based on incoming data for reasons of bounds checking. Which means that you have given us 3 static values from a range of 32767 which may be possible. ;)
I haven't checked it - but if I had to guess, I would guess, based on a vague memory of something I read somewhere, that the answer is 500 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 -----Original Message----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 05 March 2002 22:47 |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 | |The Cigarette Smoking Man: Anyone who can appease a man's conscience can |take his freedom away from him. | -- 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).
