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.
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
FRM-47001: Cannot create parameter list myparam : list with this name already exists
just you need every time to check if the parameter list exists.... If so , delete it before you try to create it. DECLARE pl_id ParamList; BEGIN pl_id := Get_Parameter_List('tempdata'); IF NOT Id_Null(pl_id) THEN Destroy_Parameter_List(pl_id); END IF; END; hope this helpfull :)
just you need every time to check if the parameter list exists…. If so , delete it before you try to create it.
hope this helpfull 🙂
See lessjava.sql.SQLException: Invalid column type Error when extending a VO
What you need to change is the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional.
What you need to change is the Binding Style from Oracle Named to Oracle Positional in the View Object declaration. The framework is adding a where clause to the query using bind variables that are typed :n, this is why you need to set Oracle Positional.
See lessoracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility.
hi beter check these two responsibilities assigned to your application user or not : Framework ToolBox TutorialFramework ToolBox Tutorial Labs
hi beter
See lesscheck these two responsibilities assigned to your application user or not :
how to create dynamic tables ,columns, and datatype for each column in oracle ?
@Hassan AbdElrahman Can you please explain problem in detail?
@Hassan AbdElrahman Can you please explain problem in detail?
See lessHow to Raise User-Defined Exception and display Custom SQLERRM ?
you can do this by using : RAISE_APPLICATION_ERROR function and here simple example for you : DECLARE custom_ex EXCEPTION; PRAGMA EXCEPTION_INIT (custom_ex, -20001); BEGIN raise_application_error (-20001, 'Your custom error message here'); EXCEPTION WHEN custom_ex THEN dbms_output.put_line (sqlerrm)Read more
you can do this by using : RAISE_APPLICATION_ERROR function and here simple example for you :
the output would be : ” ORA-20001: Your custom error message here ” .
See lesshope this help 🙂
How to know number of rows updated by UPDATE statement ?
SQL%ROWCOUNT : return the number of rows fetched/processed by the last DML executed. If the DML fails after fetching 1 row, due to any reason, SQL%ROWCOUNT will return only 1, the number of rows fetched/processed so far basically you can use : BEGIN UPDATE xx_test_tab SET test_col = 777777 WHRead more
SQL%ROWCOUNT : return the number of rows fetched/processed by the last DML executed. If the DML fails after fetching 1 row, due to any reason, SQL%ROWCOUNT will return only 1, the number of rows fetched/processed so far
basically you can use :
hope this help 🙂
See lessCan i use select statement inside if statement ? (if (select) > 0 then) ?
hello Beter, you can't use SQL Statement directly in a PL/SQL expression instead you can use variable to store your count then use your variable into PL/SQL expression like this : DECLARE v_count NUMBER;BEGIN SELECT count (*) INTO v_count FROM dual; IF v_count >= 1 THEN dbms_output.put_liRead more
hello Beter,
you can’t use SQL Statement directly in a PL/SQL expression instead you can use variable to store your count then use your variable into PL/SQL expression like this :
or as you mentioned if you want to use it inside delete statement like this :
hope this helpful 🙂
See lessHow to Insert data include symbol '&' into a table ?
it's very simple just using this : set define off insert into table values ('& yourvalues'); and then press 'F5' to execute the above commands. also from sqlplus you can use this : set define off
it’s very simple just using this :
and then press ‘F5’ to execute the above commands.
See lessalso from sqlplus you can use this :
set define off
How can i convert CLOBS TO VARCHAR2 column ?
hello Beter, you can use dbms_lob.substr( clob_column, for_how_many_bytes, from_which_byte ); and here basic two example : first by using SQL but note the max length is 4000 characters: select dbms_lob.substr( clob_col, 4000, 1 ) from Tablename; second by using PL/SQL max length is 32000 charactersRead more
hello Beter,
you can use
and here basic two example :
first by using SQL but note the max length is 4000 characters:
second by using PL/SQL max length is 32000 characters :
hope this may help.
See lessyou can refer to DBMS_LOB from oracle
Load image
firstly, try to read more about the webutil library.second, find below a basic code snippet to do the job: --this code to open uploading dialog box V_CLIENT_PATH := CLIENT_GET_FILE_NAME(DIRECTORY_NAME => NULL ,FILE_NAME => NULL ,FILE_FILTER => 'ALL FILES (*.*)|*.*' ,MESSAGE => 'Open a fiRead more
firstly, try to read more about the webutil library.
second, find below a basic code snippet to do the job:
hope this may help 🙂
See less