Oracle SQL error

[gchen]

Hi,

I have below SQL srcipt...

set serveroutput on
declare l_str varchar2(100);
begin
l_str := ConvertTimeToMST(SYSDATE,'EBB');
dbms_output.put_line(l_str);
end;

then i got error message as below...

ERROR at line 1:
ORA-00932: inconsistent datatypes: expected IN Conversion failed

I could not figure what went wrong. Any one any comment?

Thanks a million!

 

[lewisp]

Check the prototype of the ConvertTimeToMST function...