|
Well, what the ORA-00900 says is that there is something wrong with the CommandText, I'm afraid you will have to share it if you want any useful feedback
|
|
|
|
|
With these sorts of issues the first thing I do is write a really simple stored procedure to eliminate the stored procedure being an error.
Now I know you have tested the stored procedure from Oracle however I would do this anyway.
So create something like :
create procedure test_orac as
begin
declare @testvar int
select @testvar = 1
end
Then call this procedure from .NET .
If you still get the same error check your tnsnames.ora file to be sure that it points to the correct service and that the syntax within that file is correct.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Did you resolve the issue?
If you did it would be interesting to know how you resolved the issue.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
I think one more hit & run 
|
|
|
|
|
Yes ,for some, the forum works one way - it's there just to get answers to your questions and not to contribute to the wider knowledge of the community.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
please provide me good information about various locking mechanism exist in Sql server and when & where which lock is used. thanks
tbhattacharjee
|
|
|
|
|
Tridip Bhattacharjee wrote: please provide me good information about various locking mechanism
Understanding Locking in SQL Server[^]
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Since you did not provide which SQL Server the answer is several. Query BOL and you will find them. You will also need to know the type of resource that is being locked. DATABASE, FILE, OBJECT, PAGE, KEY, EXTENT, RID, APPLICATION, METADATA, HOBT, ALLOCATION_UNIT
|
|
|
|
|
we have 2 databases with phpmyadmin v5.5.31 and we want to convert data from the one to the other, so we are in need of a converter that will fix the difference of tables
is there any one who could give a hand to that?
thanks
|
|
|
|
|
Red-Gate SQL Compare works with SQL Server not sure what your DB is but it may be compatible.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello..can anyone help me on this.
I want to insert data based on the dropdownlist value. This is my database sql.
SELECT TOP (200) Actuators.id, Actuators.ActuatorInfo, Actuators.Fan, Actuators.Date, Actuators.DeviceId, Actuators.House, Actuators.DateView
FROM Actuators INNER JOIN TDevice ON Actuators.DeviceId = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id
If I want to insert data DateView into table Actuators, based on the dropdownlist for mushroom house name, how I can inner join with table TDevice and TMushroomHouse.
For example:"Insert into Actuators(DateView) Values (@DateView) INNER JOIN ..."
|
|
|
|
|
There is no "join" clause on the insert-statement. You'd insert the values you need, so I doubt you need to join any lookup-table in there.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I don't understand what exactly you want to do, but there are two ways to insert data:
1. Insert values.
INSERT INTO Table1 (Column1, Column2)
VALUES (@Value1, @Value2);
2. Insert from table/tables.
INSERT INTO Table1 (Column1, Column2)
SELECT Column1, Column2 FROM Table2
WHERE Column1 = @Parameter;
or something like
INSERT INTO Table1 (Column1, Column2)
SELECT t2.Column1, t3.Column2 FROM Table2 AS t2
INNER JOIN Table3 AS t3 ON t2.ColumnID = t3.ColumnID
WHERE t2.Column1 = @Parameter;
Best regards,
Andrius Leonavicius
|
|
|
|
|
Hello..i want to ask question.
In my database there is a column for Date such as below:
2014-03-26
2014-03-25
2014-03-24
Does anyone know how I want to retrieve data value from a previous row with select statement.If I want the latest data, so the sql is like this ORDER BY Actuators.Date DESC";and the answer I get is 2014-03-26. But if I want to show the previous data value from previous row what can I do?The result will show date 2014-03-25. Tq
|
|
|
|
|
Which database system? SQL Server 2012?
You want to get the second highest? Or both the highest and second-highest in one row?
You'll never get very far if all you do is follow instructions.
modified 23-Apr-14 13:12pm.
|
|
|
|
|
Database system is SQL Server 2012. I just want to get the second highest in a column Date.
|
|
|
|
|
You could use ROW_NUMBER and select the one with a value of 2.
Or something like:
SELECT TOP(1) * FROM (
SELECT TOP(2) StartTime FROM dbo.RunSummary ORDER BY StartTime DESC
) T ORDER BY StartTime
Neither seems very elegant.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Tqvm 
|
|
|
|
|
Syafiqah Zahirah wrote: what can I do?
..SELECT TOP 2
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
yes..it working! 
|
|
|
|
|
You try to do this by the following code:
select max(Actuators.Date)
from table1
where Actuators.Date<(select max(Actuaors.Date) from t1);
i hope it can help you.
|
|
|
|
|
I'm not sure if this is even possible. I'm trying to create a auto increment column for FID in this database file.
I was going to use SQL Server Express, but decided to just stick with the same format of the original program Account Mate for DOS, running low on quoted time for the project.
Any insight would be appreciated!
Dim m_path As String = Nothing
Dim dwXCode As Integer = registry_shared.read_HKCU_dataPath(m_path)
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_path & "; Extended Properties=dBASE IV"
Dim queryString As String = _
"CREATE TABLE ARCEMJN " & _
"(" & _
" FID AUTOINCREMENT " & _
" , FINVNO VARCHAR(10) " & _
" , FCUSTNO VARCHAR(10) " & _
" , FTRANSDATE DATE " & _
" , FCONTACT1 VARCHAR(80) " & _
" , FEMAIL1 VARCHAR(254) " & _
" , FSTATUS BIT " & _
" , FERRCODE VARCHAR(10) " & _
" , FERRMESS VARCHAR(80) " & _
" , FPDFPATH VARCHAR(254) " & _
") "
|
|
|
|
|
Some info[^] on how to use AutoInc fields in dBase.
Sorry, forget that, wrong version.
modified 23-Apr-14 1:45am.
|
|
|
|
|
Did those exist in DBase IV?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Oh bugger. I forgot to check the version.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
