Vamsi Pavan’s Place

One of the very common task in oracle environment is export/import of CSV files to Oracle database. Export is pretty straight forward as many of oracle clients provide this as standard functionality for any query. But for import, we can do by writing our own scripts using pl/sql or java or .NET or any other […]

[Read more →]

Seems like this is very common error in pl/sql programming. I know there are many last minute frustrations just because of this error which is no where related to any logic. This seems to be some format error in the programming language itself.
The error message is:

java.sql.SQLException: Non supported SQL92 token at position: 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at […]

[Read more →]

Few common errors in BPEL of Oracle SOA suite are:
1. No domain available for the current user
This occurs due to failure to contact Olite database instance while loading SOA suite in the system. As this db has the all meta info regarding the domain names etc. within the server.
You need to run Olite database bat […]

[Read more →]

Choose the responsibility as System Administrator,
1. Navigate to Security -> User -> Define.
2. Search for the user for which you want to add new responsibility.
3. Bottom page shows the current responsibilities attached to current user. There you create a new record with the desired responsibility and then save.
4. Logout of the Apps. And login after […]

[Read more →]