What are the PL/SQL Program limits ?
Question
Oraask Latest Questions
Question
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
Question
hi is there any approach in pl/sql to execute more than one procedure in one time like: BEGIN Proc1('first'); Proc1('second'); Proc1('third'); END; but ...
Question
how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
Question
hello guys can someone explain to me what is the differences by easy way and with example if possible.
Question
please i want list of all standard Oracle Inventory Reports - EBS R12 and if with short describe every report it will be very appreciatedthanks in advance.
Question
BELOW IS THE CODE AM USING:Am getting the error:"There exist uncompiled objects in the report" declare v_rep varchar2(1000):='a'; v_rep_status varchar2(1000):='a'; v_url varchar2(1000):=''; rep_status VARCHAR2(100); repid REPORT_OBJECT; thelist paramlist; begin thelist := get_parameter_list('rep_paramlist'); if not id_null(thelist) then destroy_parameter_list(thelist); end if; thelist := CREATE_PARAMETER_LIST('rep_paramlist'); ADD_PARAMETER(thelist, 'PARAMFORM',TEXT_PARAMETER,'NO'); ADD_PARAMETER(thelist, ...
Question
when trying to extend a VO actually it's extended successfully but when i trying to search for more than one time inside LOV page this exception is throwing java.sql.SQLException: Invalid column type and this full error message: oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error ...
Question
hi i have data set that has ampersand symbol "&" and i want to insert this data but when i put this symbol into values of insert statements TOAD asking for substitution value i tried to escape this symbol but it ...
Question
please i want to find way to convert clob datatype to varchar2 datatype i searched many times through google but with no valuable result.