Oracle 10XE and .NET 2005

[CRSCoder]

Hi,

WinXP SP2, Oracle10XE.

I have created several tables and procedures in XE and have "sucessfully" connected from VS.NET 2005.... sort of. For some reason VS.NET can see all the tables in the XE db except the ones I created. In Server Explorer, can see the tables and procedures. However, if I configure a SqlDataSource, it does not display the tables I created. I created these in Oracle XE as user "SYSTEM", so I assumed that connecting from VS.NET as SYSTEM, I'd be able to see the Procedures and tables.

I'm logging in from VS.NET as SYSTEM.

When trying to execute a procedure from my ASP.NET application and I see the error message:
....
Message="ORA-06550: line 1, column 7:\nPLS-00905: object SYSTEM.CMRC_CUSTOMERADD is invalid\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"
Source="Oracle Data Provider for .NET"
DataSource="XE"
Number=6550
Procedure="CMRC_CUSTOMERADD"
......

CMRC_CUSTOMERADD is the procedure. Is this a permissions issue?

Thanks in advance for any assistance.

Paul

[CRSCoder]

Argh! At least one Rookie mistake.
On the procedure, I had not compiled the Procedure. Thus the error.

However, as to why I cannot see the tables from VS.NET, still remains a mystery.

Thanks again. If this is not the right forum for these questions please let me know.

Paul

[slimdave]

I created these in Oracle XE as user "SYSTEM", so I assumed that connecting from VS.NET as SYSTEM, I'd be able to see the Procedures and tables.

I'm logging in from VS.NET as SYSTEM.

Ah, another rookie mistake

Never use the system or sys users/schemas, Paul -- funny things can happen to you. It's much more robust, and easier quite frankly, to create your own user.