SQL & PL/SQL :: How To Store PDF Files In Oracle10g DB
Dec 2, 2011how to store pdf files in oracle10g database
View 13 Replies
ADVERTISEMENT
Store Image And PDF Files In 10g?
Jan 5, 2011i want to store image and pdf files in oracle 10g.
i success with blob variable.
what are the other methods.
Store Video Files In Database?
Oct 3, 2012In my project I am storing everything in database BLOB column.Everything includes images,documents,videos and any thing uploaded from form.
video should not be save in database.I want to know it is good idea to store everything in database BLOB column?
PL/SQL :: How To Compress Multiple Files And Store In Table
Apr 9, 2013I am having many different files and i want to use pure plsql to get these files stored as blob from a table then compress them into 1 files and store that into another table. I did some search and its like possible but didnt get conclusive solution
View 4 Replies View RelatedForms :: Create A Form To Store Any Excel / Word Files?
Jul 1, 2011i m using oracle 10g forms.
i want to create a form where i can store any excel / word etc files.
Oracle10g Install On Z/OS
Apr 22, 2011I am having a rough time trying to install Oacle 10.2.0.3.0 on Z/OS 1.7.
Since my installation does not allow us to use X Windows nor Telnet, I have been forced to try to install using a silent install response file. The install does not seem to get very far and throws out an informational message, but no actual errors. All this is being done via OMVS on USS (UNIX system services).
The message I am getting is:
INFO: INFO: Unable to read the list of homes from the inventory.
I think it may be a permissions issue, and the support people are pursuing this avenue as well, but so far, no concrete answers.
I execute ./runInstaller -silent -responsefile <my responsefile.rsp>
The above INFO message comes out.
The user I am logged in with has the following:
uid=1212 (HPCGBE) gid=101(OINSTALL) groups=102(ORADBA)
One problem is that there is a superuser account called BPXOINIT that is the group owner on some of the directories that I need to access:
uid=0 (BPXOINIT) gid=1(BPXOINIT) groups=101(OINSTALL),102(ORADBA)
Forms :: Button On LOV - Oracle10g
May 17, 2011I hava LOV and i want process events when click button Cancle on LOV then disable a canvas, but i don't know how process it.where could know events click mouse in button Cancle on LOV - Oracle Forms?
View 9 Replies View RelatedInstallation :: Oracle10g For Windows 8
Mar 5, 2013I need to install oracle10g with client 6i on windows 8 platform, provide me link to download 10g with no issues installing on windows8.
View 2 Replies View RelatedServer Utilities :: Oracle10g Imp Tables Containing LOB
Nov 23, 2010A full database exported from Oracle 10.2.0.4 and import back to the same instance with different user/schema name. The whole database is in single tablespace, SOURCE_TS. Since SOURCE_TS already exist in the same instance. A brand new user and its default tablespace will be created before the import. SOURCE_TS cannot be access by this new user.
Since my database has many tables containing LOB column, those LOB tables will be pre-create before the import start. Initially, those LOB tables imported successfully but at one stage, it fails. Subsequent LOB tables all failed since then.
Quote:IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "I43NAV_LOC_VEC" ("VID" NUMBER NOT NULL ENABLE, "BLK_NO" N"
"UMBER NOT NULL ENABLE, "DATATYPE" NUMBER, "VEC_STORAGE_TYPE" VARCHAR2(12) N"
"OT NULL ENABLE, "REL_PATH" VARCHAR2(256), "BYTES_USED" NUMBER, "BLOB_DAT"
"A" BLOB, "BFILE_DATA" BFILE) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 "
[code].......
I am not able to find out any reason why it fails, since out of 150, 80 of my tables containing LOB column were imported correctly suggested that my imp parameters were correct.
It doesn't seems to be my backup file problem too, I tried twice and the first LOB table failed is not the same with the previous attempts.
Initially I thought might be quota, but unlimited quota to the new tablespace is granted. Even if it is not granted, the error returned would be complaining about quota limit reached in the new tablespace, not SOURCE_TS.
If this is not about disk space or quota issue, in what condition the imp will tries to create table in SOURCE_TS, instead of my new tablespace? I will need to understand the IMP utility logic to sort this out.
SQL & PL/SQL :: Control Session In Database Oracle10g
Sep 30, 2010i want to control our session in database oracle10g which means that:x is not allowed to connect to the database, if x try to connect to the database his session will be blocked and a message must be sent to the administrator.
View 8 Replies View RelatedODP.NET :: Is ODAC Free For Oracle10g User
Aug 6, 2012My company brought Oracle10g server some years ago. I've noticed that ODAC support Linq and could be used to connect Oracle 10g.
Can we use ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio for commerical use due we already purchased Oracle 10g server?
RAC & Failsafe :: Enable Audit_trail On 2 Node RAC ENV On Oracle10g
Nov 23, 2011I have a production database with 2 node Physical RAC ENV on two separate machines , and we are going to enable audit trail parameter to DB values to capture all failed login attempts on a database.
we have done this on our testing ENV but dont know the procedure to deploy this steps on 2 node RAC ENV . I have done the below steps on our standalone testing ENV
1.Log in as SYS and connect with the SYSDBA privilege.
oUser Name: SYS
oPassword: Enter your password.
oConnect As: SYSDBA
2.To enable audit on DB use below command
SQL>alter system set audit_trail=DB scope=SPFILE;
3.Then restart the database.
4.After successful startup use the below command to capture log
SQL> audit create session whenever not successful;
steps to enable audit_trail to capture failed login attempts on two node RAC ENV.
Precompilers, OCI & OCCI :: Oracle10g Pre Compilation Error
Apr 23, 2009i am getting below error when i compiler a pro*c program with Oracle 10g client with IBM C compiler version 9.0 on AIX 6.1
Syntax error at line 183, column 2, file /usr/include/sys/socket.h:
....
PCC-S-02201, Encountered the symbol "sa_family_t" when expecting one of the foll
owing:
....
My pcscfg.cfg contents
sys_include=(/usr/include)
ltype=short
PL/SQL :: How To Implement Exception Handling On MERGE Statement In Oracle10g
Jul 19, 2012How to handle the exception on below MERGE statement?
MERGE INTO COMM_EXSTS_COMIT_AGGR TARGET
USING
(
select * from ABC ) SRC
ON
(
SRC.COMMITMENT_ID = TARGET.COMMITMENT_ID
)
WHEN MATCHED THEN
UPDATE
WHEN NOT MATCHED THEN
INSERT ;
Performance Tuning :: Oracle10g Standard Edition On Linux Machine
Jan 16, 2012In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.
SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K
Our Database size is 700GB approx.
The above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is almost 99%.
Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix
Jul 31, 2008I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:
Quote:unable to open include file
#include <stdio.h>
and other C library headers.
I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:
proc program.pc
No problems, and I do get program.c.
However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.
Know If Database Files Are On File System Or Raw Files?
Oct 11, 2012How can I know if database files are on file system or raw files?
View 4 Replies View RelatedCompare Two Dump Files And Their Respective Log Files
Jun 20, 2012I want to compare two dump files and their respective log files, to see the difference. Is there any way.
View 8 Replies View RelatedSQL & PL/SQL :: Hiding Store Procedure Possible?
Jan 11, 2012I have a question like, Is it possible to hide the Store Procedure?
Scenario: I have write the SP which contains some logic based on my requirement. Once i developed this i need to implement this to my client page. So i need to hide the logic even the client opened the SP like exe file.
SQL & PL/SQL :: How To Store Xml In Blob From A Query
Jul 13, 2012i want to store xml in database. i have following questions,
1) in which col should i keep xml .
2) right now i am keeping it in blob columns, how can i insert update a record in blob col from query, which can be run from worksheet.
I am using oracle 11g express edition.
Forms :: How To Store PDF In Database
Mar 23, 2010I want to store files in the database using oracle forms 6i. The file may be in the form of .pdf .
Its possible, if yes How to code in form.
SQL & PL/SQL :: Script Store Data?
Feb 10, 2013My requirement is to get primary key column name and there values of a table and store in a stage table
create table easy(id integer, event_rowid integer,txn_rowid integer,txn_name varchar2(200));
begin
for i in 1..5 loop
insert into easy values(i,'777'||i,i||89,'Ris'||i||i);
[code]...
I was able to fetch primary keys and there values for a table and store them in stage table but only 1 record , I am stuck when there are more than 1 record Here is what i tried
SQL> SET serveroutput ON
SQL> DECLARE
2 V_prim_key VARCHAR2(2000);
3 l_tab DBMS_UTILITY.uncl_array;
[code]...
If you look at the above code in the execute immediate where condition i have used id=1, which is 1 records only but if i change id <3 then there will be 2 records and i will get below error ORA-01422: exact fetch returns more than requested number of rows
Other problem if there are 3 primary keys as in above case i am fetching there values 1 by 1 , is there any way if i can fetch those values once in for all data to be stored in stage table in below format
TAB_NAME V_PEIM_KEY V_PRIM_DATA DT
------- --------- ------- ------
EASY TXN_NAME,EVENT_ROWID,ID Ris11,7771,1 10-Feb-13
EASY TXN_NAME,EVENT_ROWID,ID Ris22,7772,2 10-Feb-13
SQL & PL/SQL :: How To Store Value In Date Variable
Oct 17, 2012i am having one query which is
select to_char(date '1900-01-01' + 1439/(24*60),'DD/MM/YYYY HH24:MI:ss')from dual;
when i am running this query i am getting this value: 01/01/1900 23:59:00 and this value i am inserting in one variable which has date datatype.here i am storing like this:
v_nshiftmax := to_char(date '1900-01-01' + 1439/(24*60),'DD/MM/YYYY HH24:MI:SS');
while storing getting error: not a valid month....how to store it in this variable?
SQL & PL/SQL :: Right Way To Store IPV4 And MAC Address
Jan 26, 2012The title for this new topic is self explanatory. Since PostgreSQL has data types for storing IPV4 and MAC address and Oracle don't, I would like to know the right way to store this values so we can do different operations and validations with these network address.
I been doing some research but I don't like the solutions like storing just number values whit out any validations like PostgreSQL.
PL/SQL :: Store XML Data In Tables
Jul 21, 2012I Have to write a procedure which takes XML data and inserts into some tables.
If the XML format is fixed then i can use extract function for parsing and can insert into the tables.
But the problem is there is not fixed format for the xml.
Are there any built in packages which takes the xml data for parsing..
SQL & PL/SQL :: FIFO Store Consumption
Apr 25, 2013I need a query to divide the total consumption of an item into parts as it was stored in store on the basis of FIFO. The item that was stored first it will consumed first.
My sample data is given below.
DROP TABLE STORE_STOCK;
CREATE TABLE STORE_STOCK
(
no NUMBER(4),
vdate DATE,
code VARCHAR2(8),
clqty NUMBER(8,3),
dept_id NUMBER(4)
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
[code]........
SQL>select * from store_stock
2 order by dept_id,vdate,no;
NO VDATE CODE CLQTY DEPT_ID
---------- --------- -------- ---------- ----------
359 21-JUL-12 012-042C 1050.1 19
2144 14-NOV-12 012-042C 990 19
1876 23-OCT-12 012-042C 1010 34
4006 12-MAR-13 012-043D 515.425 34
4086 15-MAR-13 012-043D 870 34
4495 13-APR-13 012-043D 498 34
6 rows selected.
SQL>select * from store_issue;
CODE IDATE DEPT_ID QTY
-------- --------- ---------- ----------
012-043D 24-APR-13 34 1650
012-042C 24-APR-13 19 990
Required Output will be
NO VDATE CODE CLQTY DEPT_ID ISS_QTY BAL_ISS
---------- --------- -------- ---------- ---------- ---------- ---------
359 21-JUL-12 012-042C 1050.1 19 990 0
2144 14-NOV-12 012-042C 990 19 0 0
1876 23-OCT-12 012-042C 1010 34 1010 640
4006 12-MAR-13 012-043D 515.425 34 515.425 124.575
4086 15-MAR-13 012-043D 870 34 124.575 0
4495 13-APR-13 012-043D 498 34 0 0
The total consumed against code '012-042C' is 990 for dept_id 19 and we have stored qty 1050.1 against goods receipt no 359 dated 12-jul-12. So have issued the whole qty against no 359 and balance is 0. For item code '012-043D' the total issuance is 1650 and we have issued it against 03 goods receipt nos.
Store Procedure Insert / Update?
Dec 7, 2011Store procedure code, I want to insert data in a database in this fashion,I want to check first if the record exist, if not Insert or else Update.
View 2 Replies View RelatedTo Store Data In Materialized View
Apr 14, 2011I have a PL/SQL procedure which gathers data from multiple places as well as calculates some data. I want to store all this in a materialized view.
So, I created an object type (I've shortened the definitions):
CREATE OR REPLACE TYPE mf_record_type AS OBJECT
(identifier VARCHAR2(6),
name VARCHAR2(100));
Then created the table type of the object:
CREATE OR REPLACE TYPE mf_table_type IS TABLE OF mf_record_type;
Then in the stored procedure defined a variable of the table type:
v_mf_record mf_table_type := mf_table_type();
Then I loop and populate the record type:
v_mf_record.EXTEND(1);
v_mf_record(x) := mf_record_type(v_rec.identifier, v_mf_detail.name);
When all that is done I try and create the materialized view:
EXECUTE IMMEDIATE ('CREATE MATERIALIZED VIEW mf_snapshot_mv AS
SELECT * FROM TABLE (CAST (v_mf_record AS mf_table_type))');
ORA-00904: "V_MF_RECORD": invalid identifier
Am I doing something wrong here? Can't I create the materialized view based on something other than a physical table?
SQL & PL/SQL :: Store Image In Oracle 9i Table
Jan 3, 2012I want to store Image file in Oracle table without storing it physically in the system. how can i store the image file into the oracle table and also retrieve it without storing it physically in the system at any path.
View 5 Replies View RelatedSQL & PL/SQL :: How To Store Images In Table Column
Dec 21, 2011How to store images in table column. I have table called emp with datatype empno,name,photo_id(long raw)
.
i want to store image in table for each record.
