Search results for query: *

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 &quot;1&quot; 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 !