Hello,
As i explained my problem in the last message. In fact, it work good for the connection etc. But yesterday morning, it show me this error. After, i waited maybe one hours, it re-work. and this problem is arrived since yesterday till now, i mean that it work and not work, after waiting a moment it re-work again...That why, i want to understand that.
Sorry if i can not explain clearly with my poor english. Thanks in advance.
trakal
Last Activity: Sep 28 '07, 02:40 PM
Joined: Jun 28 '07
Location:
-
[error]: ORA-12516: TNS:listener could not find available........
Hello all readers,
I have a question concerning an error that i really want to understand.
I have an application client (C#) that connect to an Oracle server. Normally, it work good but just this morning, i have an error that the message is like below.
ORA-12516: TNS:listener could not find available handler with matching protocol stack.
I didn't do anything just do someelse and after maybe 1hours, i try to connect to... -
Hello Saii and all the reader,
So thanks alot for your helps Saii, it's so helpful. i can now solve my problem as your proposition by creating the procedure with OUT refcursor in Oracle and (Id) IN number.
One time again so thanks.
TrakalLeave a comment:
-
Hello Saii and all readers,
Sorry that i couldn't have a good explaination in english. I try now to re-ask the question in another way. here are my problems.
My application is writed in C#, use ODP.Net and call the stored procedures in Oracle database (the procedures are created in the type of method CRUD "Create, Read, Update and Delete").
In fact, i want to create a procedure to replace the select query such...Leave a comment:
-
can i do something like SQL Server?
For exemple: SELECT DISTINCT o_user := USER FROM DUAL;
I think that it's impossible. But i just try to ask you all if you already see this problem and solve it.
Thank....Leave a comment:
-
Hello,
As i said recently that my application need to use the procedure in the Oracle Server and display the result in client. We don't want to use the query directly.
All the method, that we use in the application (in C#), call the procedure to display the data.
Thanks before for all and so welcome for all your suggestions....Leave a comment:
-
1. I use "EXECUTE IMMEDIATE" as i wrote before that this procedure is not compiled without this command.
2. This procedure is very important for my application console writing in C#.
In my application, i create a method called LoadById(string id). This methode use this procedure to get the data from the Oracle database. For example, i use this method by using the parameter "id", so this parameter's value will be...Leave a comment:
-
Hello amitpatel66
Thanks alot for your answer. Yes sure, i can use the cursor. But my project is not to use that because this procedure will be used with the application writing by C#.
Because we use the procedure by using the OracleCommand and to read the data by OracleDataReade r of ODP.Net. So we don't want to create the cursor in the server (oracle).
do you have any suggestions?
i'm ready to answer you all the questions,...Leave a comment:
-
[pl/sql] Problem of select and display the result
Hello everybody,
i have a problem that i don't know how to solve it.
I created a procedure like this:
create or replace
PROCEDURE Employee_LoadBy Id
(
p_Id NVARCHAR2
)
AS
BEGIN
EXECUTE IMMEDIATE 'SELECT DISTINCT "Employee"."Id" , "Employee"."Nam e", "Employee"."Las tWriteTime", "Employee"."Cre ationTime"... -
good morning,
Thanks alot for your answer.
Have a nice dayLeave a comment:
-
Hello amitpatel66 and everybody,
So thanks for your quickly answer. this answer is useful for me.
But if you don't mind me, can i ask you another question because this code is look complicated for my programme.
I don't know if you know SQL Server.
Let see this example in SQL Server
CREATE PROCEDURE [dbo].[test]
( @username[nvarchar] (64) = NULL)
AS
IF@username IS NULL
...Leave a comment:
-
[pl/sql] Assign a query's value to a variable
Hello everybody,
i create a stored producedure in Oracle that will get the user name who connect to Oracle database.
For exemple, i declare a variable "o_user" and i want to assign the value of the query (select user from dual) to the variable.
It's possible?
i know that it's possible to do by this statement "select user into o_user from dual". But i want to know if we have another way to do... -
Hello,
First, i want to say thanks to parag100 and debasisdas who answered me.
I can now find the solution for my problem.
My solution is the creation of the scripts (for exemple CREATE TABLE tab (col NUMBER); ) and i use ExecuteNonQuery to execute this scripts.
after the execution this script. the table "tab" will be created in the database.
So, i can use DDL's operation through C# by using the scripts...Leave a comment:
-
I just want to reform my question asked before.
i'm now developping a application who connect to Oracle database as a DBA. the objectif is to let a user (DBA) to connect to the schema of DB, and can display the objects owned by that schema: tables, synonyms, constraints. moreover, this user can also create the database's objects as i asked before to do DDL operations(crea te, drop and soon).
Now i find a assembly of ODT.Net named...Leave a comment:
-
Hello,
Thanks for your reply.
So, do you mean that i can't do any DDL operations in the script SQL through
C#?
ThanksLeave a comment:
-
Hello Debasis,
Thanks for your reply.
I want to create an application in C# that let create the schema of database (or user) and objects of database ( tables, index, stored procedures,...) .
Actually, i can only connect to the Oracle database (existing) by the connection string and do the query or call the procedure but i can not create schema of database or tables directly. To do that, i must to write the scripts sql and call...Leave a comment:
-
Administration Oracle Database in C#
Hello all,
I'm a new one in this forum and also the one to developpe the application database in C#.
I want to administer the Oracle database (Express Edition) in C#. It's mean to create a schema of user or delete a user etc.
In summary, i want a class that let me to do as DMO or SMO that Microsoft developpe for SQL Server.
So thanks before for all your helps.
PS:Sorry, if i post this subject in the wrong...
No activity results to display
Leave a comment: