User Profile

Muhammad Intikhab Qaiser · Jun 7 '07, 08:43 AM

Hi

I am developing a windows application in which i need to find names and ipaddresses of all the computers connected within a LAN on which MySQL 5.0 and Oracle 9i is installed.When application executes,it retrieves name and ipaddresses of the computers and show it to user.I am develping my application in C# 2.0 and using .NET framework 2.0.

Thanks

Muhammad Intikhab Qaiser · Jun 7 '07, 06:54 AM

Hi

I need to find dependency information on procedures and functions, if this function is called from some other procedure or is dependent on a table

What I need is

1.Which views reference table 'A'
2.Which procedures or functions refer to table 'A'
3.What are the tables (or views) being used by view 'X'
4.What are the tables (or views) being used by procedure 'Y'...

Muhammad Intikhab Qaiser · Jun 7 '07, 05:22 AM

Hi

i want to connect to oracle 9i from .Net using oracle ODP.NET.But when i download and install ODP.NET it stops all my oracle services.Now i even cannot logon to the oracle SQL*Plus engine.

How i can install ODP.NET properly and use it.

Thanks

Muhammad Intikhab Qaiser · Jun 7 '07, 05:14 AM

Hi

I am developing a parser to parse the stored procedure and function definition of MySQL.I need to extract the names of stored procedures,func tions and tables which are being used in any particular stored procedure definition.How i can get this information?

Also i want to know at what places within the stored procedures are the names of tables and other stored procedures can be used?

Thanks

Muhammad Intikhab Qaiser · Jun 7 '07, 05:10 AM

Hi

As Oracle uses PL/SQL for the stored procedure and SQL Server use T-SQL for itself

What MySQL use for its stored procedure programming

Thanks

Muhammad Intikhab Qaiser · Jun 7 '07, 05:05 AM

Hi
I have following code and problem in calling the oracle stored procedure "DEPTREE_FI LL"

Here is the Code:

Command.Connect ion = connection;
Command.Command Text="deptree_f ill".ToUpper() ;
Command.Command Type = CommandType.Sto redProcedure;

OracleParameter par1 = new OracleParameter ("objectType ", OracleType.Char );...

User Profile

Profile Sidebar

C# Programmers:Locating MySQL and Oracle instances installed within the LAN

Find dependencies between database objects of MySQL

Installing ODB.NET

Build parser for MySQL stored procedure

What database programming language used by MySQL for stored procedures

Calling Oracle Stored Procedure from c#.net 2.0