var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CAST function in assignment statement ?
In the below procedure I couldn't use the cast function in assignment statement. Please explain ?
create or replace procedure test
var2 := cast(var as float);
But the following query works fine :
select cast(sno as float) from test
( Here sno is of int datatype )
Please advise, how can I solve this in procedure level.
Would this be OK?
CREATE OR REPLACE PROCEDURE TEST
var2 DECIMAL (19, 4);
SELECT CAST (var AS FLOAT)
Thanks for your reply. But this is not working in Oracle 8i. I too had tried this earlier. Any solution for Oracle 8i ?