Solaris

dears

kindly i give this error when i load package in solaris to oracle db


SQL> @ typfc_pb.sql

Warning: Package Body created with compilation errors.

SQL> show error
Errors for PACKAGE BODY TYPFC_P:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1394/1 PL/SQL: SQL Statement ignored
1400/6 PL/SQL: ORA-01733: virtual column not allowed here
SQL>

Murad,
this is an error in your sql code and is not related to a problem with Sun Solaris. I think you have posted this in a wrong forum. The place to turn to is a Oracle forum.

I can try to give you some hints on the SQL code even do this is not in the scope of this forum. You could post it to this forum and I will have a look. In the future I think it is better to turn to http://otn.oracle.com or some other place where there are a lot more people discussing Oracle PL/SQL.

For now, what I can see is that you have a ORA-01733 error message, most likely, looking at this error code, you are trying to insert, update or delete something in a view. This is not allowed. Instead of modifying the data in the view you should modify the data in the parent tables of the view.

Regards,
Johan Louwers.