PL/SQL :: Get Runtime Parameter In SQL File?
Dec 11, 2012I want to get runtime parameter in .sql file . read values at runtime in .sql file
View 6 Replies
ADVERTISEMENT
Application Express :: Dynamic Reports - Runtime Parameter Passing To Report Query
Jul 27, 2013I have developed a report using apex shared components (report query and report layout) along with BI Publisher for report printing in pdf format. the Report template is built using Template Builder for Word. I have configured my Apex4.1 env with BI Publisher 11. This report is working fine for hardecode ID ( like REQUEST_ID=10 ). to make report dynamic i have made following additions in the report
I have added where clause in report query as WHERE REQUEST_ID = :REQUEST_ID (:REQUEST_ID is the text field in my page).
Added a text field names :REQUEST_ID to get user input at run time.
Create a button and add Repot Query URL in its properties. When i run the report with some valid value in :REQUEST_ID text field i did not get expected result infect there is no record getting displayed in the PDF file. i think this is not the write way to do this but interestingly im not getting any error. how can i get this functionality in apex this way or the other ?
Forms :: Upload A File From The Client To App Server In Runtime?
Jul 16, 2013I need to upload a file from the client to app server in runtime.
Opening some kind of explorer to choose the file then upload the file and safe the path in a database column.
SQL & PL/SQL :: Generate A Select Query In Runtime And Store Results Of It Into A File?
Aug 15, 2011I need to generate a select query in runtime and store the results of it into a file.Each time the column name and table name in the query will differ.Now im able to generate the select query through for cursor but problem is to store the results to the file.I tried using plsql table,im able to get the values to that table and store the results to a file,but the results of the query is more then 10000 lines (it might increase also)where only 4000 characters where able to store in the plsql table.so rest of them are not stored in the file.
View 3 Replies View RelatedRecreate Parameter File When Lost Or Corrupted?
Jul 1, 2010recreate paramater file if you lost init.ora or spfile.ora
STEPS
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:ORACLEORA92DATABASEINITGPT2.ORA'
How to resolve ORA-01078 with LRM-00109 error?
For resolving these error, you should need to replace init.ora or spfile if you have backup of same files. If you don't have backup then go to alert.log and copy all parameters in one file and save as "init.ora". Modify same init.ora with some parameters which need single quotation mark " ' " like background_dump_dest,controlfiles,db_name and "dispatchers ......)". Connect as sysdba in SQL*Plus and execute command "create spfile from pfile=" or startup pfile or startup.
Server Administration :: UNDO In Parameter File?
Dec 9, 2011I have a question ragarding undo tablespace. I want to ask that why only undo tablespace information we need to specify in parameter file. We do not specify any other tablespace information. Not even for temporary tablespace. Then why we need to give undo tablespace name while instance is creating.
View 5 Replies View RelatedRAC & Failsafe :: How To Know About Listener.ora Parameter And The Endpoints File
Apr 2, 2010information on this listener.ora parameter and the endpoints file? There is no reference in the docs (except for a sample listener.ora file in the RAC Installation Guide, no explanation).
Following a clusterware with gPNP installation, the listener.ora file has only IPC addresses, plus this parameter:
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))# line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))# line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))# line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON# line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON# line added by Agent
The endpoints_listener.ora file specifies the fixed and VIP addresses of the public NIC:
LISTENER_GR7244=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.196.182.201)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.196.180.44)(PORT=1521)(IP=FIRST))))# line added by Agent
The listener named LISTENER is in fact listening on both its IPC address, and the addresses in the endpoints_listener.ora file:
[grid@gr7244 admin]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2010 04:52:02
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
[code]...
The scan listener on this node is listening on its IPC address, and its VIP:
[grid@gr7244 admin]$ lsnrctl status listener_scan3
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2010 04:46:15
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN3
[code]...
I did wonder if this parameter and file could be part of the mechanism whereby a listener discovers the DHCP assigned VIPs on which it has to listen?
Write Shell Script To Parse Parameter File
Mar 29, 2013I'm working on trying to write a shell script to parse a parameter file, but at the same time I want to be able to overwrite the parameter file settings with other command line settings. For instance if my par file had export/import settings for the username, password, schema, etc;
I wanted to run the same export/import with those settings for a different schema. I want to be able to put the schema=<different_than_par_file> after the parfile=<parfile.par and have the parfile be read and applied for everything except the different schema.
Right now I'm storing the cmd line and parsing it again looking for other parameters besides the parfile.
Server Administration :: Initialization Parameter File - Currently In Effect For Session
Jan 31, 2012I have a question about spfile.
SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20
v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.
RESUMEABLE Parameter / No Space Left On File System Export Fails
Dec 2, 2010I have some question about the parameter RESUMABLE 10G. My quesition is suppose if i am running a expdp process and if there is no space left on the file system the export fails. So in this case if we set the RESUMABLE parameter in the DB will it be useful to resume the expdp from where it fails or it will useful if we schedule a job for the export.
View 2 Replies View RelatedMonitoring Runtime Of Procedures
May 23, 2013runtime monitoring procedures....need a sample script
View 1 Replies View RelatedForms :: How To Get Reports Runtime
Nov 27, 2011How can I get forms and reports runtime and from where?
View 2 Replies View RelatedForms :: Getting Runtime Remarks?
Aug 12, 2010 find the attached file.i want to get the remarks on runtime.i have written this formula in when_validate_item.
declare
a number;
begin
a := nvl(:get_mark,0);
if a >= (33/100)*:get_mark then
:remarks := 'PASS'
[code]...
SQL & PL/SQL :: Create A Table In Runtime?
Feb 15, 2012I want to create a table in runtime.
SQL> select 'Test'|| '_' || extract(day from sysdate) ||
2 lpad(extract(month from sysdate), 2, 0)
3 from dual;
'TEST'||'_'||EXTRACT(DAYFROMSY
-----------------------------------------------------
Test_1502
SQL>
I want to create a table with this table name 'Test_1502'
I am using the create command as:
SQL> create table Test || '_' || (select extract(day from sysdate) ||
2 lpad(extract(month from sysdate), 2, 0) from dual) as
3 select * from Emp;
create table Test || '_' || (select extract(day from sysdate) ||
lpad(extract(month from sysdate), 2, 0) from dual) as
select * from Emp
ORA-00922: missing or invalid option
SQL>
XML DB :: Set Field Length At Runtime
Jul 17, 2012can I control at length of field at tuntime?i want to set the number of the size (length) at runtime.
(no by use "HORIZONTAL ELASTICITY"= variable/expand because I need a specific length)
SQL & PL/SQL :: How To Execute One Query Result In Another At Runtime
Dec 14, 2011I have a query, when i run this this will give another sql statement. I want run this dynamically...
How to proceed?
Forms :: How To Add Text Items At Runtime
Dec 24, 2012I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies View RelatedForms :: Change Image In Runtime?
Nov 10, 2011how can change image through runtime i mean if have 5 pictures first image will showing and second image showing
View 1 Replies View RelatedPerformance Tuning :: How To Measure SQL Runtime
Jun 26, 2011Is there any other ways to measure a sql run time more accurate and more efficient? I meant using a spool and set timming on like this.
[oracle@milo ~]$ cat measure_sql.sql
spool result.txt;
set timing on;
select * from t3 where empno=7788;
set timing off;
spool off;
[oracle@milo ~]$ sqlplus scott/tiger @measure_sql.sql
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 27 01:36:32 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
16 rows selected.
Elapsed: 00:00:00.01
JDeveloper, Java & XML :: Generating XML From XSD At Runtime?
Aug 13, 2012I Have got a requirement where we have to generate an xml conforming to a particular XSD.
What i will be having already in place is an XSD document.
We are thinking of making a procedure which will be recieving the set of inputs required for creating that xml.(Data content of that XML.)We would have to make the XML according to that XSD.
Everytime Parsing the XSD is not feasible.We are looking at a solution which would be easy to make the xml from xsd at runtime.These values (DATA) will be available at run time.
SQL & PL/SQL :: Selective Column Details On Runtime
Apr 10, 2011I have tables dynamically created with dynamic number of columns. There will be 7 columns that would always be fixed with their names and data types. They will always be last 7 columns.
way to write a select statement on those dynamic tables where only those known 7 columns are not selected and I need to select all the rest columns but leave the 7 columns names I know.
Forms :: How To Hide A Button While Runtime
Mar 30, 2012We have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.
Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?
Reports & Discoverer :: Runtime Search?
Sep 11, 2013I want to search the record in a report. I want option when the reports forms is running.
View 6 Replies View RelatedForms :: How To Read Application URL Runtime
Apr 21, 2009Is it possible to read the application URL while running the application
[URL]
Above is my URL i need to read i and t hold it on a variable at runtime
SQL & PL/SQL :: Passing Column Name To Cursor At Runtime?
Apr 15, 2013in below program,i have to pass column name to cursor at runtime..but this giving error.
DECLARE
TYPE EmpCurTyp IS REF CURSOR;
v_emp_cursor EmpCurTyp;
emp_record hr.employees%rowtYPE;
v_stmt_str VARCHAR2(200);
colname varchar2(10):='Last_name';
BEGIN
[code]....
dbms_output.put_line(emp_record);
*
ERROR at line 13:
ORA-06550: line 13, column 1:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
ORA-06550: line 13, column 1:
PL/SQL: Statement ignored
Forms :: Setting Icon At Runtime
Feb 12, 2010i want to set the icon on my forms i write these lines.... for to do this...
MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCOMPANY.ico', 0);
and i also attached the library d2kwutil.pll and when i run the form then this error raised...
FRM-40734: Internal Error : PL/SQL error occurred..
now what can i do for set the icon at run time..the first part of the message has been removed as it belongs to @allianz2010's previous topic; the rest has been split into a new.
Forms :: Text_items Are Not Visible In Runtime
Apr 3, 2013I have one form that is migrated from oracle forms 6i to 11g. I opened that form by 11g form builder and it has 3 text items. Then i run the form from 11g builder...here is my problem, only 2 text items are displayed in my browser(IE). another one is invisible... i checked the property pallet for that particular text item.
i checked the following properties and its value in my form:
enabled=yes
visible=yes
but the text item is not visible.
SQL & PL/SQL :: Resetting Character Set At Runtime Of Procedure?
Oct 18, 2013We have procedure that writes text to an Excel file.
The 10g database is setup for US7ASCII character set. This causes the characters on the Excel spreadsheet to appear strangely. As an example an 'a' would appear with a character similar to '~' on top of the 'a'.
If there anyway of resetting the character set at runtime of the procedure.
Forms :: Create Runtime In Oracle 10g Like 6i?
Sep 27, 2013Can We Create Forms Runtime in Oracle Forms 10g Like Oracle Forms 6i
View 1 Replies View RelatedForms :: Positioning Canvas At Runtime
Apr 26, 2012i need to position my canvas at run time.
View 3 Replies View Related