Forms :: File Upload Show No Record
Aug 30, 2010
Using Forms 10g and Webutil. I am uploading my file using the following code. The Status shows file upload is Successful.. but NO Record exists in the Table...!
Here is my Table Structure:-
CREATE TABLE ST_ATTACHMENT_ACCOUNT
( ACCOUNT_CDE NUMBER(8,0) NOT NULL,
FILE_NAME VARCHAR2(100),
FILE_BLOB BLOB)
TABLESPACE PRODTABLES;
Here is my -
PROCEDURE UPLOAD_DB IS
lb_success boolean;
ls_full_filename varchar2(200);
ls_filenm varchar2(100);
BEGIN
[Code]...
It shows me the progress bar for upload also but I cannot see any record on the table.
SELECT dbms_lob.getlength(FILE_blob)
FROM ST_ATTACHMENT_ACCOUNT
WHERE ACCOUNT_CDE = 2;
0 rows selected... what is wrong...?
View 8 Replies
ADVERTISEMENT
Oct 8, 2013
oracle forms 6i
oracle ebs 11.5.10
database 9i
i create new custom application in my ebs 11i and i want to upload file in our custom application and save it as file system in my server lunix
how i attach my file and i want to save it not as blob but just upload to my server and after download it?
View 2 Replies
View Related
Jan 23, 2013
I'm using oracle 10g and Forms 9i . I need to upload a PDF file from client to server no to database, just like File, is there any way to get it, no webutil using.
View 1 Replies
View Related
Nov 6, 2013
Do you have sample codes to upload file from client to server using 11g forms?
View 2 Replies
View Related
Apr 19, 2010
I want upload file to server and i know i can use Java Bean but i don't know how i use java beans?
View 3 Replies
View Related
Oct 29, 2010
I want to create a form in oracle 10 g . In this form i want download & upload any excel file.
View 2 Replies
View Related
Mar 27, 2011
I have a major issue because I have to finish this project by tomorrow and I don't know how I could create a button on a form that will pop a window where the user can browse his system for and Image, select it and upload it on the Database.
The idea is that I have this table called APPLICANTS with columns like:
applicant_id
name
surname
housenumber
street
town
photo
I have created a registration form for the applicant inorder to register to the system but I just can't figure out how to upload a photo of the applicant.
View 5 Replies
View Related
Jul 16, 2013
I 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.
View 3 Replies
View Related
Aug 9, 2010
i want to upload a word file to database.I wrote the following code
create or replace directory MY_FILES as 'C:Uploadfolder';
Create table emp1(
EMPNO number(30),
EMPNAMe varchar2(10),
RESUME BLOB);
[Code]....
ERROR at line 1: ORA-22288: file or LOB operation FILEOPEN failed No such file or directory ORA-06512: at "SYS.DBMS_LOB", line 523 ORA-06512: at line 10
View 32 Replies
View Related
Jun 20, 2012
I am getting a following odd result where the same a Job could be linked to multiple enquiries. What I want it to show is just one job if its linked to multiple enquiries. I show you some sample result:I wrote the following SQL for it:
SELECT
'Enquiry' as Origin,
job.job_number,
enquiry.enquiry_number as Defect_or_Enquiry,
job.site_code,
central_site.site_name,
job.priority_code,
priority.priority_name,
job.target_comp_date,
'Target Completion Date required' as Due_Date
[code]....
Is there anything you would add so that it shows just a unique job number where the job has multiple enquiries linked to it? I tried putting SELECT DISTINCT but that did not work.
View 11 Replies
View Related
Sep 24, 2012
I have a scenario for which I need to show same record twice.
i.e
SELECT EMPID, ENAME FROM EMP WHERE EMPID IN (101, 102, 101);
Result:
101 - Rahul
102 - Ravi
101 - Rahul
Is this possible with a single query.
View 7 Replies
View Related
Jun 30, 2011
When i create report in master detail. When detail record end on the page, the second record show on same page. Problem is that detail show on other page. I want that if record is completed on that page then ok. Otherwise it show on next page.
View 3 Replies
View Related
Nov 11, 2010
I want to show 1 record per page in matrix report. I set Main section orientation as landscape and width is 14. but it show multiple records on single page.
View 2 Replies
View Related
Feb 4, 2013
I want to upload file using restful service This is my code to send file to rest service
MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);
[code]...
But how can i retrive at server side in restful service using plsql?
View 0 Replies
View Related
Aug 2, 2012
I am trying to upload big files to individual table with BLOB column. During upload process after long time approx. 2h I get the following error message:
[#|2012-08-01T19:03:01.667+0200|WARNING|sun-appserver2.1|java.lang.Class|_ThreadID=27;_ThreadName=httpSSLWorkerThread-8082-2;_Reques
tID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
java.io.IOException: ORA-01013: user requested cancel of current operation
[code]....
I am using Glassfish Server v2.1.1 with APEX Listener v1.1.3.243.11.40...The Timeout parameters for JDBC settings in APEX Listener are default. Thus I would expect to abort earlier to be an issue of JDBC Connection?
View 1 Replies
View Related
Apr 15, 2013
I'm using Oracle Database 11g R2 need to upload Telecom CDRs to the database on daily basis , it's huge data and changeable , an example of my file in linux Redhat 5 server as below ,
INDRtotalduration = 00:00:00
origin_matrix = 4186603ec003ef01
triggering_key = 665000207
Start_Date_And_Time = 03/04/2013 09:24:10
IMSI = 418666651000207
[code]......
there is no problem with this i think i can use SQLLDR to upload this file , but the problem here the positions of the columns in the file could change depending on user behavior it could be the first row comes in the third row or any row and maybe more rows appears ,
locind = 0
origin_matrix = 4186603ec003ef01
Start_Date_And_Time = 03/04/2013 09:24:10
INDRtotalduration = 00:00:00
IMSI = 418666651000207
triggering_key = 665000207
[URL].......
this is sample of the file i could be more than 100 rows , and the position of the field and field names could be change every time depending on the Subscriber usage , is there any way to upload the file but after checking the field name in the file and matching to corresponding column name in the table .
View 5 Replies
View Related
Apr 17, 2013
After Upgrading to Apex 4.2
When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.
View 0 Replies
View Related
Jan 4, 2013
I needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.
Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):
CREATE TABLE "TABLE"."STG" (
"DUMMY01" NUMBER,
"DUMMY02" NUMBER,
"DUMMY03" NUMBER,
"DUMMY04" DATE,
"DUMMY05" CHAR(3 BYTE),
[code].........
And here's the insertion process:
DECLARE
v_blob_data BLOB;
v_blob_len NUMBER;
v_position NUMBER;
v_raw_chunk RAW(10000);
v_char CHAR(1);
[code]..........
If I run a process to produce the output of the data array onto the screen, the values displayed are in the pattern desired.
Inserting Dummy values instead of values from the Array (v_data_array) to test
EXECUTE IMMEDIATE 'insert into TABLE.STG (DUMMY01, DUMMY02 ..... DUMMY65)
VALUES (
60040,
5,
TO_DATE("14-Dec-12","DD-MON-RRRR HH:MI:SS"),
"ABC",
"ABC",
60,
"11DEC1201",
"331",
"SCOTT TIGER",
"MARKETING",
[code].......
Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.
View 1 Replies
View Related
Sep 19, 2012
I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.
The function looks as follows:
FUNCTION SFTP_CMD (
V_USER IN VARCHAR2,
V_PASS IN VARCHAR2,
V_HOST IN VARCHAR2,
[code]..
where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)
View 2 Replies
View Related
Sep 11, 2013
In my project, I implement file's upload and download function by "BLOB Support in Forms and Reports" of official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.
View 1 Replies
View Related
Jun 8, 2011
Iam working with a form thru which I need to port nearly 7 laks of data into table. Earlier I had created a form thru which I read the data from the text file and inserting into the table. This was taking lot of time and as well after an hour or so, after porting 50k rows the program got terminated and shows an error like Network Inturpted.
So I have decided to use some other option and found that I can use either SQL Loader or external Tables. I had choosed SQL loader option and created a form along with a control file and batch file based on some forum posting.
Control File
LOAD DATA
INFILE 'D:SethuPayClock DumpCLK_050611clock_dump.txt'
INTO TABLE ARS_CLOCK_DUMP
(TDATE POSITION(01:08) DATE 'YYYYMMDD',
VER POSITION(09:10) CHAR,
EMPNO POSITION(11:15) CHAR,
TTIME POSITION(16:19) CHAR,
BRADD POSITION(21:22) CHAR
)
[code]....
With above all the form works perfectly in local system which is the development evironment and also client PC. And I was able to port those 7 laks rows in 3 miniutes. Now the real problem, If I need to move this to live application server, I had to move three files [ FMB, CTL and BAT ]. I have some problems in moving the other two files to the application server [ waiting for approval from bozz ]. And more over, I had to hard code the user id and password in the BAT file, i think which may not be a best practice and also not safe.
So I have decieded to do all from forms and found same sort of script. I took it and modified to my needs.Code from form's when button pressed which is not working
declare
usid varchar2(10):= get_application_property(username);
pwd varchar2(10):= get_application_property(password);
db varchar2(10):= get_application_property(connect_string);
msqlldr varchar2(300);
ctrl_filename varchar (300) := 'D:SethuPayModifiedFormsars_clock_dump.ctl';
data_filename varchar2(300) := 'D:oracleproduct10.2.0db_1BINabc.dat';
fname varchar2(1000);
[code]....
View 32 Replies
View Related
Jan 18, 2011
I have upload an image in forms6i, in oracle apps
On button press event, code is...
DECLARE
V1_PATH VARCHAR2(50);
BEGIN
V1_path := get_file_name('C:IMAGE', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
DECLARE
[code]....
But it giving error message when preesing the button i.e. FRM-47105: NO image name specified.
View 2 Replies
View Related
Jun 1, 2010
I'm new to using Webutil to upload and view files and am receiving the error msg 'WUT-113 Too many rows matched the supplied where clause' The process works fine for uploading photos but not when I try and upload documents and pdf files.
The code example (for documents) is outlined below but think that the issue must be to do with some sort of incorrect Webutil configuration on my machine.
declare
vfilename varchar2(3000);
vboolean boolean;
[Code]...
The :blob_id column is populated on the form with the when-create-record trigger. Why is the program at time of upload to the db saying that more than 1 row is being written to the db table?
View 4 Replies
View Related
Nov 24, 2010
download / upload data from / to database through oracle forms 6i which is deployed in oracle apps 11i.I am using DDE/OLE2 but it is downloading if form is stand alone but when i post this form in my UNIX server, it is not downloading.
Oracle apps is in UNIX and i want excel to be in client (windows).what procedure to be used.
View 1 Replies
View Related
Oct 3, 2010
I have used webutil_file_transfer.Client_To_AS_with_progress to upload files from client to Application Server using Forms 10g.However, now i want to save file in database and not upload to database as blob.I mean I want to save the file from client TO a folder available in the database server.I was wondering, there is no documentation available on WEBUTIL.
View 6 Replies
View Related
Dec 20, 2011
I have dump file of 17 GB,which i want to import in my database db1 in user amol ;so i created new user under db1 as below ,before this i have created tablespace so that i can import my data only to that tablespace only. My steps are as below.
CREATE TABLESPACE ptaxold1 DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/cvsdbm/ptaxold1.dbf' SIZE 6024M AUTOEXTEND ON;
create user amol identified by amol default tablespace ptaxold1 temporary tablespace tem; imp amol/amol then i mentioned my dump file but after importing it does not show any table under user amol.
View 12 Replies
View Related
Dec 6, 2010
i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this
begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....
View 8 Replies
View Related
Jul 26, 2012
My procedure proc_ex is in when_validate_item trigger
I have one Multi Record data block in my form with values in its items
I need to Populate multi record block values to one Record Group using
add_group_row,
add_group_column,
set_group_char_cell to populate values to record group
Let us suppose my multi record data block looks like
item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80
how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies
View 3 Replies
View Related
Jun 26, 2012
I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies
View Related
Mar 12, 2013
i have succusffly install webutil and also i did configuration also using this url
[URL]...
and i succussfuly upload and download .pdf using my form on my test database server my test database its a single database its version also 10.2.0.4.0 .but when i upload and download my .pdf file on my live database server using this same form its give me error while upload
Quote:FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509
my live database server its a RAC Database server its version 10.2.0.4.0 . i serach on google on this ora-06509 they told me
Cause: This indicates a version clash between some package distributed with an Oracle product and the product executable.
Action: Contact Oracle Support Services.
but my question its my test database server and live database both server version are same its 10.2.0.4.0 just only its differece its test database its a single database server and live its a rac database server.
View 14 Replies
View Related
