how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
Question
Oraask Latest Questions
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.
Question
ayaaliExplorer
Hello,How can I load an image from the server and save it in the application on oracle forms, please?Thanks
Question
BeterExplorer
hi i face this error oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility. when i'm trying to run welcomePG from jdeveloper i applied all jdeveloper configurations correctly but i don't know why this error is raising. this responsibility assigned to my ...
Question
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true