Re: Procedure Builder and standard functions

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
===============================================================================