Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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 ...
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 ...
how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
hello guys can someone explain to me what is the differences by easy way and with example if possible.
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.
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, ...
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 ...
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 ...
please i want to find way to convert clob datatype to varchar2 datatype i searched many times through google but with no valuable result.
Hello,How can I load an image from the server and save it in the application on oracle forms, please?Thanks
