I want to raise user defined exception but with custom exception error message something like this : DECLARE ex_custom EXCEPTION; BEGIN RAISE ex_custom; EXCEPTION WHEN ex_custom THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; The output is "User-Defined Exception" ...
Oraask Latest Questions
hi all, i have a string getting from variable in my controller like this : String Vstr = pageContext.getParameter("Myfield"); now i want to use this variable in sql statement but if i pass this variable like +Vstr in my sql ...
Hi, I'm using forms and reports 11g. I want to pass date parameter from forms to reports. Using Add_Parameter(param_id,'P_DATE_FROM',TEXT_PARAMETER,:BLOCK.DATE_ITEM); But it's not working with strange error when trying to call report from forms please help.
I face this error when I try to call report from forms 11G which I'm using parameter list (my param) to pass parameters to report from forms please give me a solution for this error thanks in advance.
i faced this error when trying to call pdf or any other format report from oracle forms REP-52262 Diagnostic output is disabled oracle report version : 11G oracle forms version : 11G your help will be very appreciated.
I want to create new column say (ID) with auto generated sequence number with auto increment by 10.how can I achieve this in oracle database 11g ?