This is not true. the client does not communicate with the procedure. Oracle shadow process does. It's always a pointer.
regards, Waleed -----Original Message----- Sent: Wednesday, March 06, 2002 11:58 AM To: Multiple recipients of list ORACLE-L I think we are talking at cross-purposes here, the point I was trying to make was that the declared parameter doesn't have the '200' associated with it that you might assume it to have by virtue of its apparent association with the table. Bear in mind, by the way, that if a client machine calls a server procedure, the bit about pointers and IN parameters is irrelevant. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th 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: 06 March 2002 16:31 |From 9i DOC: | |Suppose a subprogram declares an IN parameter, an OUT parameter, and an IN |OUT parameter. When you call the subprogram, the IN parameter is passed by |reference. That is, a pointer to the IN actual |parameter is passed to the corresponding formal parameter. So, both |parameters reference the same memory location, which holds the value of the |actual parameter. | | | |Waleed | | | |-----Original Message----- |<mailto:[EMAIL PROTECTED]> ] |Sent: Wednesday, March 06, 2002 9:58 AM |To: Multiple recipients of list ORACLE-L | | | |Bear in mind that you cannot declare a procedure like this: | procedure blah( | p in varchar2(200) | ); |it has to be: | procedure blah( | p in varchar2 | ); | |So even though a declaration like Rob's | test.col_01%type |appears to tell Oracle that the parameter |is limited to 200 bytes I believe there is no |limit, other than the inherent limit of varchar2(), |viz: 4,000. | | |Jonathan Lewis |http://www.jlcomp.demon.co.uk <http://www.jlcomp.demon.co.uk> | |Next Seminar - UK, April 3rd - 5th |http://www.jlcomp.demon.co.uk/seminar.html |<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 |<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: 06 March 2002 13:49 | | ||Initially is will be nothing unless test.col2 has a default value as ||varchar2 structures are data_length followrd by actual string. The |maximum ||that p_in_one can have is 200 bytes thought due to its anchored |definition. || ||The answer, none initially as it will be initializes to NULl value, |then ||whatever you assign ti it plus 2 bytes to store the length of the |actual ||string, max size is 200+2 bytes (assuming standard characterset). || ||This has no baring on max size of varchar2 because by definition of ||p_in-one, its max length is limited to 200. || ||Raj ||______________________________________________________ ||Rajendra Jamadagni MIS, ESPN Inc. ||Rajendra dot Jamadagni at ESPN dot com ||Any opinion expressed here is personal and doesn't reflect that of |ESPN Inc. || ||QOTD: Any clod can have facts, but having an opinion is an art! || | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |<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: 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: Khedr, Waleed 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).
