problem with a pl sql function

[fabianoSouza Souza]

Hi, I'm having problems with the return type of the following function:

CREATE OR REPLACE
FUNCTION xxx
(
idX NUMBER,
idY NUMBER)
RETURN DATE
IS
BEGIN
RETURN (SYSDATE);
END xxx;

--What is wrong with this code? it seems that if the return type is different from the parameters type then this result in a error.. is there an solution for this? does anyone knows?
I can't change the return type and the parameters type..

[Agador Paloi]

Seemed ok to me, but dont know why you need the parameters.

  
SQL> edit
Wrote file afiedt.buf

  1  CREATE OR REPLACE
  2  FUNCTION xxx
  3  (
  4  idX NUMBER,
  5  idY NUMBER)
  6  RETURN DATE
  7  IS
  8  BEGIN
  9  RETURN (SYSDATE);
 10* END xxx;
SQL> /

Function created.

SQL> set serveroutput on;
SQL> edit
Wrote file afiedt.buf

  1  declare
  2  begin
  3     dbms_output.put_line(' date =  ' || xxx(1,1) );
  4* end;
  5  /
date =  29-APR-09

PL/SQL procedure successfully completed.
  

[fabianoSouza Souza]

well,, should be something with sqlDeveloper.. I don't know

[Agador Paloi]

works just fine without the parameters :

 
 SQL> edit
Wrote file afiedt.buf

  1  CREATE OR REPLACE
  2  FUNCTION xxx
  3  RETURN DATE
  4  IS
  5  BEGIN
  6  RETURN (SYSDATE);
  7* END xxx;
  8
SQL> /

Function created.

SQL> @temp;
date = 04-MAY-09

PL/SQL procedure successfully completed.
SQL> list
  1  declare
  2  begin
  3     dbms_output.put_line(' date = ' ||  xxx );
  4* end;
SQL>