here's all the transactions after downloading oracle:
-start application start database;
-started get started with oracle database application 11g express edition;
-selected application express menu;
-'re logged in with the credentials defined sys + password to the installation;
created a workspace with:
- Username: db;
- Application username: dbase;
- Added password;
- Open the workspace I went on sql workshop;
- Then I clicked on sql commands;
- And I put the following commands:
- CREATE TYPE emp_person_typ AS OBJECT (
manager REF emp_person_typ );
-CREATE TABLE emp_person_obj_table OF emp_person_typ;
-INSERT INTO emp_person_obj_table VALUES (
emp_person_typ ('John Smith', NULL));
-at this point I will get the following errors:
ORA-00932: inconsistent datatypes: expected NUMBER got REF db.emp_person_typ
I only do these operations I did! I did not change anything but these problems presented to me.
I also tried on two different machines but nothing changes. help me!!!
is there any special reason, why you are working with Object Types and tables ...?
The second attribute of your EMP_PERSON_TYP is a REF datatype; which is a "pointer" to another
object (a row) in the same table. APEX SQL Workshop cannot deal with these "REFs" ... you would
have to exclude this column in your select list or to DEREF the reference beforehand ...
But again: Do you really need own datatypes or would "plain" tables with attributes also work ...?
this is a pure SQL Workshop restriction. If you try it in SQL*Plus, everything will work. Just SQL Workshop in APEX does not know how to deal with
a column of REF datatype - so ... you might either use SQL*Plus or, within SQL Workshop you need to exclude the attribute.
its part of the database - the "normal" SQL prompt for Oracle. On a windows installation it should be listed in the start menu. On the "DOS prompt", typing "sqlplus" shoud also work. The "sqlplus.exe" ist located in the folder of your Oracle Installation in the subfolder "bin" ...
found! The problem is that I ask you for credentials that are not the classic account sys
also wanted to ask: after I started sql * plus I can work in APEX or do I have to do everything from the command line?
I just wanted to confirm that the application that I have on my machine is:
Oracle Database Express Edition 11g Release 2
Edited by: 981149 on 11-feb-2013 4.42
I think, what you need, is a thorough tutorial for working with OracleXE ... you might try these in order to get an understanding, how to connect to the database and how to create tables, views and how to work with APEX. It should then be easy to get your very examples working ...
but I know where you retrieve the credentials to access sqlplus?
if you do not want to use the REF as I could simulate such a thing?
please give me a chance to figure out how to do so as fast as possible because I have the time counted