I am a beginner to ireports.I want to create an ireport with oracle 11g using the default tables present in xe. I used EMP table from xe and it showed error ORA-00942 table or view does not exist when i run the query select * from EMP. Please help!!!
ireport cannot recognize the table from oracle 11g database
78 Views Asked by himani chauhan At
1
There are 1 best solutions below
Related Questions in ORACLE11G
- Whatever the data available in previous record it should add to the new record
- Identifying invalid dates in Oracle database due to daylight saving time changes
- How to perform arithmetic calculation between rows in oracle Pl/Sql
- Oracle Performance Slow with Select Union From Dual in Join Statement
- How to reduce the size of tif files before inserting into the oracle database
- Passing table name dynamically each time
- ORA-06550 and PLS-00306 Errors When Calling Stored Procedure with UDT Table Parameter using ODP.NET on .NET 6
- oracledb.exceptions.DatabaseError: DPY-4011: the database or network closed the connection - python oracledb library
- Spring boot oracle 11g sequence stored is different from the value shown in the model
- Update or Insert into table, using rows from same table
- how to fix PLS-00306: wrong number or types of arguments in call to 'DEQUEUE'
- Oracle materialized view refresh on two different schedules
- How may I perform OCIPing (or equivalent) from a .Net application?
- is the documentation for oracle-sql and mysql the same with respect to the definitions, syntaxes and rules?
- How to Extract Database Connection Information from JInitiator 1.1.8.16 Files?
Related Questions in IREPORT
- ORA-01008 Not all variables bound error on Oracle Apex application
- How can I filter weekends and holidays with iReport?
- In Ireport 4.7.1 , socket creation error is coming while connecting to database
- iReport 3.7.3 crashing on startup on windows 10
- iReport compile error (java.lang.String cannot be resolved) in maven NetBeans project
- Can't connect to the socket for mysql running under docker from the host?
- java.awt.image filed class in jasper not found
- Possibly deprecated JDBC MySQL driver in iReports, can't import new one
- How do you download and launch iReport from maven/gradle?
- How to debug java.lang.NullException error in iReport (JasperReport) using javafx in netbeans with MS SQL Server Database
- How can I use having clause outside the subquery?
- How do i print a row x amout of times, where x is a value in this row?
- SolaimanLipi font is breaking the connected word in iReport exporting PDF
- ireport cannot recognize the table from oracle 11g database
- How to create iReport with two different data source of Main and Subreport
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Generally speaking, you should connect to user that contains tables you'd like to use in the report you're creating. So, if it is
EMPtable and it belongs to Scott, connect as Scott.By default, its username/password combination is
scott/tiger(all lower case). There's a chance that it (user) is locked. If so, connect to the database via SQL*Plus or SQL Developer or any other tool you use (as a privileged user, such asSYSorSYSTEMif there's no other you have - I presume you don't) and do the following:After that, establish connection to Scott in iReport (providing previously mentioned credentials) and you should be able to query the
EMPtable.