Hi!
To obtain a value using dynamic SQL, in Oracle I used
EXECUTE IMMEDIATE 'SELECT name FROM emp WHERE empno = :no' INTO lcv_name USING lnv_empno
where:
lnv_empno variable with employee ID value
lcv_name variable filled after statement execution with employee name
In SQL Server i can execute...
Hi !
I need to extract data from a binary type variable the way i can extract string data using SUBSTRING. In Oracle i used UTL_RAW package, but in SQL i don't know how to do this. Can anyone help me ?
Thankx!
I had to simulate a tree in SQL so a used a recursive procedure, but i receive an error message ( "Maximum stored procedure nesting level exceeded" ). What can i do to solve this situation? Does anyone know if i can remove the limits for recursive calls ? Thanx !
Hello,
i'm working with T-SQL stored procedures and i am interested in obtaining the formated error message from sysmessages when a constraint violation occurs. i can obtain the error message using a select from sysmessages table based on the number of error i received through @@ERROR, but the...
Hello,
i'm working with T-SQL stored procedures and i am interested in obtaining the formated error message from sysmessages when a constraint violation occurs. i can obtain the error message using a select from sysmessages table based on the number of error i received through @@ERROR, but the...
Could anyone tell me if there is a formula which i could use to give proper values ( in order to increase performance ) to parameters used in the "storage" clause from "create table" ?
The params which I consider are:
INITIAL, NEXT , MINEXTENTS, MAXEXTENTS, PCTINCREASE...
I've installed Oracle 8.1.5, 8.1.6 and 8.1.7 on Windows 2K Professional without problems (even if i had to work on 64 RAM). Right now i'm using 8.1.6 on Win 2K.
Well, in Oracle u can retrieve for example all children for parent given by "1" value using:
select parent, level from OrgTree where parent <> 1 start with parent = 1 connect by prior child = parent;
each field returned from this query has an associated pseudocolumn called LEVEL...
Ok, here is what i've tried...
Open Visual Foxpro and create a test database. then click on Connections. In the dialog box click New.
You have now 2 choises: to specify a datasource or a connection string. If you hadn't declared the specific datasource for your Oracle connection you can do it...
Could anyone tell me what should i do to be able to call a function such as OutputDebugString( string ) from within my stored procedures ? Or maybe someone knows if I can use a tool such as DebugViewer to see messages sent from within my stored procedures at runtime ... Please help me!
Tankx !
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.