Bytes - answers

How do I transfer data from Oracle Forms into MS Excel?

gjones — Tue, 17 Nov 2009 11:48:38 GMT

I have an Oracle Forms application and I want to populate an Excel spreadsheet with some data from the application.

I am using the DDE.Poke command to transfer data into the spredsheet and that is fine, but there are some merged cells on the spreadsheet that will not allow data to be transferred to using the DDE.Poke command, DDE.POKE(docid, 'R9C8',tmpdateperiod, DDE.CF_TEXT, 1000);

Is there a way that I can populate merged cells in Excel from Oracle Forms?

Thanks in adavnce

ora-01110:datafile 1: '/usr5/system/system/01.dbf

umeshmistry — Fri, 13 Nov 2009 07:22:50 GMT

ora-01033 : oracle initialization or shutdown in progress errors: come

need Department details

vamsioracle — Thu, 12 Nov 2009 06:04:23 GMT

Hi All,

How can we find the department details of a person in Oracle HRMS. Which table defines the departments and the link between employee and department.

Thank you

vamsi

image from db to local drive

cmuraz — Thu, 12 Nov 2009 05:18:00 GMT

helo all,

i need to get image files from oracle database to local drive say "c:\photos"

i dont know the procedure to do it. i want to know how to do it and in which format i ll get in the local drive

pls help me regarding this.

thanks and regards

muthu

how to export oracle database to a flat file

ghjk — Tue, 10 Nov 2009 10:05:56 GMT

I want to export oracle(version 9.2.0.1) database to a flat file. How can I do that? Is there any free tools for that? Found a tool called data loader but it is a commercial one.

Join columns

Broun — Mon, 09 Nov 2009 10:13:11 GMT

i WANTO JOIN A TABLE ON ITSELF (IS THAT WHAT IT IS, I DONT KNOW).
I HAVE A TABLE SAY:

Expand|Select|Wrap|Line Numbers

	
TIME                    READING                        READER

=============================================

15                       8                                   A

20                      11                                  A

25                       9                                   A

30                       7                                   A

10                      875                                 B

20                      431                                 B

30                      678                                 B

11                      28.3                                C

16                      31.9                                C

41                       25.9                               C

I want to extract the following table

Expand|Select|Wrap|Line Numbers

	
TIME                         READER_A           READER_B          READER_C

-=======================================================

10                                                           875

11                                                                                     28.3

15                            8

16                                                                                     31.9               

20                           11                             431                  

25                            9                    

30                            7                             678

41                                                                                     25.9

Tried a couple of methods and am now lost. Any help guys!

How can we Check if Oracle stored procedure already running

rash123 — Mon, 09 Nov 2009 08:46:31 GMT

Hi all ,
Please help me on the the following query
How can we Check if Oracle stored procedure already running

ERROR: You do not have SELECT priviledges on sys.V_$PARAMETER view.

2desperate2usedesperate — Sat, 07 Nov 2009 18:19:15 GMT

ERROR: You do not have SELECT privileges on sys.V_$PARAMETER view. This process cannot proceed.

Hello,
I am using ORACLE 10g Standard Edition and I am trying to configure the Oracle Designer for which a repository must be installed. The following is the procedure I am following:

START >
PROGRAMS >
ORACLE
DEVELOPER SUITE �DevSuite1 >
DESIGNER >
REPOSITORY ADMINISTRATION UTILITY

I am connecting to the database from which the repository will be formed. So I enter the following
Enter the following

Username: SYSMAN

Password: password

Connect String: orcl

When I login to the Repository Administration Utility,
I click "Install" and I follow by clicking all the affirmatives. (see attachment)

So this is what I do after:
1. I Open up command prompt

2. ENTER: sqlplus sys/change_on_install@orcl as sysdba

And I receive the following:

SQL*Plus: Release 10.1.0.4.2 - Production on Sat Nov 7 14:04:41 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:

-----------------------------

SO I then enter the username:
Enter user-name[/i]:SYSMAN
Enter password: ********

and this is the outcome:
Connected to:
Oracle Database 10g release 10.2.0.1.0 - Production

SQL>

I then enter:
GRANT SELECT ON sys.V_$parameter to SYSMAN;

and I receive this:
GRANT SELECT ON sys.V_$parameter to SYSMAN;
*
ERROR at line 1:
ORA-10301: Insufficient Privileges

Can anyone tell me what I am doing wrong, please?
(I'm not experienced in using Oracle)
Thanks in advance!!!

Attached Thumbnails

How do I create a Data Dictionary using Oracle Designer

student2 — Fri, 06 Nov 2009 18:28:35 GMT

Hi,
I'm fairly new to Oracle (I'm using the 10g DB and Developer Suite)

I have an assignment that requests the following:-

DATA DICTIONARY
"Use Oracle Designer to produce a list of attributes for each entity."

I was able to produce the ERD, DFD and PD, however, I do not quite know how to begin to produce the Data Dictionary.

Any help in this area would be appreciated, thank you!

loading xml file into oracle with dtd validation on,

xavierite — Fri, 06 Nov 2009 11:41:27 GMT

I am using this method to insert into table of xmltype

INSERT INTO xml_table
VALUES (XMLType(bfilename('XMLDIR','Test_xml.xml'),
nls_charset_id('AL32UTF8')));

xmlfile is like this

MRF
20040512
08305555
BAS_STREET_SEGMENT
1
vector digital data

one

ERROR at line 2:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00202: could not open "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd"
(error 101)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 295
ORA-06512: at line 1

I need to used dtd validation, i cannot turn off dtd, is there anyway that i can use dtd validation in oracle.I read a white paper
which says that while inserting into xmltype dtd validation is supported.

db version is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
&
client i am using there is internet connection, and database server is on different machine(without internet), this file "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd" is available on internet.
Pl help, thankx

portint database from oracle to postgres

ghjk — Thu, 05 Nov 2009 04:42:44 GMT

I want to port oracle database to postgres. How can I do that? Is there any tool for that or do I need to convert query by query?

convert number to date

lucaluca — Sun, 01 Nov 2009 12:43:18 GMT

I have a Table that represent many istant time with two column:
Column 1:
istant time that is writted by a number 10 characters that are the seconds from 1/1/2000;

Column 2:
also in this column there is a data, that is year (YYYY): months (MM) ; Day (DD).

I need to rapresent the visible colum outside converting the first colum, or if is useful, also the second column, with the format:

year (YYYY): months (MM) ; Day (DD) : hour (HH) minute (MM) second (SS).

Thanks for help

oracle error. Ora 01033 orcle instalation or sutdown in progress

vikramkundal — Fri, 30 Oct 2009 03:42:37 GMT

plz send me the solution of this error

thank you

jasper and IReport against Oracle

mkotula — Thu, 29 Oct 2009 17:48:13 GMT

Hi,

Brand new to jasper and IReport with Oracle.

Was able to load and connect IReport to Oracle DB and created my first reports.

Unable to connect Jasper to the DB nor import my IReport created reports.

Jasper and IReport running on Windows, Oracle on a different UNIX server.

Please help if you can.

Regards,
Martin

Discoverer Query

vamsioracle — Thu, 29 Oct 2009 14:09:16 GMT

Hi

I have a disocoverer report registered in Apps. Now hw can i find out the detail of that report in apps.

I have navigated through application develoer --> application--> form function and searched for the report name (identifier in desktop version) in the user fucntion name. It shows there is no such record.

If i have the report name and identifier, how can trace the registered report details.

Vamsi