I got this working by clearing few syntax errors and also by
correcting the hard coded timestamp format, I had to give milliseconds
as well.
create or replace procedure TEST_TIME_PROC (
v_SYS_ATTR_VALUE_ID NUMBER,
v_last_upd TIMESTAMP
) as
begin
merge into TEST_TIME t1
using (s
Comments embedded.
On Jun 12, 12:11 pm, John wrote:
> Hi All,
>
> I need to pass Date value to a procedure for inserting into a table.
You're attempting to pass a TIMESTAMP, not a DATE.
> But the date will be hard coded date as opposed to system date.
Again, you are not passing any DATE value
Hi All,
I need to pass Date value to a procedure for inserting into a table.
But the date will be hard coded date as opposed to system date. It
works for me when I tried with sysdate but fails when I am giving hard
coded date value, think I am missing some conversion here. Can some
one please hel
