Embedded SQL related errors

Possible error when executing an embedded SQL: ErrorMesage: 42883:
function up_ods301_005(integer, timestamp with time zone) does not
exit

Debugging technique:

When an embedded SQL reports an error, the recommended way is to
run the PowerServer Web APIs in debug mode, and check the SQL statement
in the Output panel.

For example, the original embedded SQL is:

select * from up_ods301_005(20,'1981-01-01');

1	select * from up_ods301_005(20,'1981-01-01');

And the actual statement shown in the Output is:

select * from up_ods301_005(@P0,@P1)
@P0 = 20
@P1 = 1981-01-01 12:00:00.000

select * from up_ods301_005(@P0,@P1)

@P0 = 20

@P1 = 1981-01-01 12:00:00.000

You will find that the data type of the second parameter does not
match the two statements (the first one is date, and the second one is
timestamp with time zone) (for more accurate data type information, use
the web debugging proxy tool).

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?

Connection Information

Embedded SQL related errors – PB Docs 2022

Embedded SQL related errors

My Website Links