Re: Procedure Builder and standard functions

From: Axel Rose <rose_at_wmdhh.wmd.de>
Date: 1995/07/11
Message-ID: <1995Jul11.135422.12111_at_wmdhh.wmd.de>#1/1


Hi Russ!

Thank you very much indeed for your valuable hint!

ERROR 306 was reported at all occasions where I used string concatenations.
e.g.
dbms_output.put_line( '->' || field_name_or_local_variable ); substr( field_name_or_local_variable, 1, 2 ) Using "to_char( field_name_or_local_variable )" helps.

But because you are working at Oracle perhaps you can tell the net when Procedure Builder will work with PL/SQL V2 ??

Axel

Russ Seligman (rseligma_at_oracle.com) wrote:
: In article <1995Jul8.170439.12624_at_wmdhh.wmd.de> rose_at_wmdhh.wmd.de (Axel Rose) writes:
: >I am trying to use Procedure Builder to debug my stored procedures.
: >When I drag those procedures from the database to the local "Program Units"
: >compilation terminates with
: >ERROR 306 at line 1258, column 21
: > wrong number or types of arguments in call to 'to_number'
 

: Procedure Builder 1.5 uses PL/SQL V1 on the client side, and PL/SQL V2 on the
: server side. PL/SQL V2 is a bit more intelligent about implicit conversion of
: datatypes. For example, the following will compile in V2, but not in V1:
 

: PROCEDURE foo IS
: BEGIN
: dbms_output.put_line('foo' || 6);
: END;
 
: To make it compile in V1, you need to explicitly convert to the appropriate
: datatype:
 

: PROCEDURE foo IS
: BEGIN
: dbms_output.put_line('foo' || to_char(6));
: END;
 
: This is most likely the problem you're encountering.
 

: --Russ
 

: ===============================================================================
: Russ Seligman "If there's nothing wrong with me, maybe
: Oracle Corporation there's something wrong with the universe."
: rseligma_at_us.oracle.com --Beverly Crusher, ST:TNG
: ===============================================================================

--
Axel Rose - Hamburg, Germany     "Ich bin der Geist, der stets verneint!
e-mail: rose_at_wmdhh.wmd.de         Und das mit Recht; denn alles, was entsteht,
phone : +49-40-58958-236          Ist wert, dass es zugrunde geht;
fax   : +49-40-58958-199          Drum besser waer's, dass nichts entstuende."
Received on Tue Jul 11 1995 - 00:00:00 CEST

Original text of this message