Re: Procedure Builder and standard functions
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