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.
ADVERTISEMENT
Forms :: How To Store PDF File In Database
Dec 18, 2010I want to store pdf file in table using forms 6i. Then i want to open and view it in Acrobat Reader. using Forms 6i only.
View 1 Replies View RelatedForms :: Code To Store Images Inside Database
Jan 11, 2011//To load an image from the Hard Disk
//Level : Item
//Type : Trigger
//Name : When Button Pressed
Declare
[code]......
Now what should be the code to store this image from the image box inside the database? I done a lot of time with Oracle Data Base 11g with the Form Builder 6i and 10g but all in vain . No image store inside the database but browse button work well.
Forms :: Create Different Database Users Like STORE / PAYROLL
Apr 12, 2011I create different database users like STORE, PAYROLL, GL , SYSADMIN, COMMON to contain objects accordingly then I create another user ABC and grant DBA privileges to all users.
After that I grant SELECT/INSERT/UPDATE/DELETE privileges on each and every objects of STORE/PAYROLL/GL/SYSADMIN/COMMON users to ABC then create synonyms of STORE/PAYROLL/GL/SYSADMIN/COMMON users objects into ABC.
Actually, I want to use single user of ABC to build/execute my application but I think I am doing something wrong because whenever I tried to compile my form, its showing this error.
Forms :: Transaction Data Which Should Store Temporarily In Database?
Sep 17, 2013I have a Data entry form which is a multirecord block;
Question: for example that form has 10 to 25 fields or columns more than that all the data has been entered, but before committing or saving that form i need to cross check the the data with a select query, whether the data entered is correct or not but before committing, that data it should be posted into that table if i find that one data is entered wrongly then i will modify that and again cross check and save the transaction permanently into the database table?
SQL & PL/SQL :: How To Store Special Character In Database
Aug 19, 2010i want to store special characters in database. i have tried following but not succeed. how to store and retrieve it. Herewith i'm posting my try.I want to store and retrieve following character.
SQL> select nchr(181) from dual;
N
-
µ
SQL> create table temp (uom varchar2(10));
Table created.
SQL> insert into temp values(nchr(181));
1 row created.
SQL> commit;
Commit complete.
SQL> select * from temp;
UOM
----------
?
here i'm getting the '?' but i want 'µ'.
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?
Security :: Where To Store Static SQL (Application Or Database) And Why
Feb 6, 2013 understanding where to store the static SQL code (Database or Application).Consider a scenario, that I am executing a simple SQL from Java which is returning some value, and it will not be changed in future.
should I store this sql in java application code or in database in form of procedure/function and returning the result to Java. Is there any security/performance impact?
SQL & PL/SQL :: How To Store External File (XLS / Doc / PDF) Format In Oracle Database
Feb 1, 2011I want to stored the excel or ms word document in oracle database. Is it possible to view that file from database. If i export full database it is included in that dmp.
View 5 Replies View RelatedGlobalization :: How To Store India Regional Language In Oracle Database
Mar 5, 2013How can we store data in Indian regional languages in Oracle database. We are using Oracle 10g.
Also i need to know can we convert existing data in oracle to local language ?
Forms :: Read Data From Excel And Store It In Blob?
Aug 10, 2010I am getting the file using CLIENT_GET_FILE_NAME. I need to read the data from the .xsl file and convert it into blob. The file should not be stored in DB.
View 8 Replies View RelatedForms :: Store Report Output In Client Machine Through Oracle 11g
Aug 24, 2011i am generating report from oracle forms using web.show_document .pdf output is coming in seperate url.entire piece of code is working fine.now i want to store this pdf out put in client machine whether path will be specified by user.
View 3 Replies View RelatedForms :: How To Store Word / Excel Documents To BLOB Column
Mar 29, 2011My client system is WinXP.I want to store a Word/Excel document to Oracle Blob column and choosed the command named "piecewise.exe",it seems a free tool on the web, to store the document to oracle,but occausionally failed.So I need alternative which is stable and available.
View 1 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.
Forms :: Checkbox Checked On Runtime And Store In Global Variable
Feb 6, 2010I have more then one checkbox on my form,I want to get which one is checked on runtime and store it in global variable?
View 6 Replies View RelatedForms :: PDE-PLI011 A Tools Common Schema Table Missing From Object Store
May 26, 2011while trying to open an exisitng Form, an Error message appears as:
PDE-PLI011 A tools common schema table is missing from the object store.
and failed to open. what's the problem ? what i have to do ? it was working fine before.
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.
SQL & 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.
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 :: How To Store PDF Files In Oracle10g DB
Dec 2, 2011how to store pdf files in oracle10g database
View 13 Replies View RelatedSQL & 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.
SQL & PL/SQL :: How To Store A Large String In Oracle
Nov 20, 2009how do i store large string in oracle.
View 19 Replies View Related