Re: SPL to replicate a row with serial key
In article <EBJE6y.Ev@nonexistent.com>, Jacob says...
>
>I, Jake Salomon, just posted this procedure and the errors involved:
>
>>
>> Hi Family.
{SNIP]
>
>YUCHH! I know it would be tedious! But it would be worth it if it would
>at least work. Alas, I get the identical error message about..
> 670: Variable(order_num) declared as SERIAL type.>
>And BTW, listing the columns in the INSERT statement didn't help either.
>
>Now... Any ideas?
>
>Thanks much!
>--
> -- Jake (Currently wishing to be an undomesticated aquatic avian)
>
>+----------------------------------------------------------+
>|Aside from that, how did you enjoy the play, Mrs. Lincoln?|
>+----------------------------------------------------------+
Hi, Jake,
It does not like your declaration - serial is not allowed in SPL even in this
form. Consider this procedure :
create procedure haha(onum like orders.order_num)
-- do nothing
-- do nothing once again
end procedure;
Now, execute procedure haha(10) falls over with so familiar -670.
The bottom line - use integers instead !
Cheers,
Ilya
---
Standard disclaimers apply.