Search results for query: *

The command line expdp allows for not exporting grants (as did exp). However, I cannot get that feature to work with the APIs. Has anyone done this with the API?

Executing the equivalent of SELECT DBMS_SQLTUNE.report_tuning_task('SQL TASK') FROM dual It produces the general information section; the SQL ID; the actual statement and then generates an Error Statement. ORA-00942 Table or View does not exist. I trapped for the error and the trace...

I several did timings of these two options for cursors and found INSENSITIVE consistently faster, which surprised me. Does anyone have any experience with the INSENSITIVE option and it ability to scale. It appears to have a higher usage of TEMPDB space which is a concern in our environment.

We have a production system where the CPU was pegged at 100%. When I analyzed the saved data (sysprocess and profiler results) it appeared that at the start of the high CPU usage there were quite a few deadlocked processes (6+). But why would this cause the high CPU usage? It would seem that...

We have two processes going, one polls sysprocesses and the other is sysprofiler. Both have measurements for CPU usage in milliseconds. According to documentation CPU usage on sysprocesses is a cummulative total. However, we are seeing CPU milliseconds in the sysprocesses for a SPID that are...

Of course. I will be a little clearer. Lets say we have a table with two entries Name1 1/1/2000 1/1/2005 Name2 6/2/1950 1/2/1953 The desired output would be Name1 1/1/2001 Name1 1/1/2002 Name1 1/1/2003 Name1 1/1/2004 Name2 6/2/1951 Name2 6/2/1952 Of course add_months can...

We have a need to, with a query, to return the number of rows into a report that represent the number of years between two dates. So, we have a start date of 1/1/1999 to 1/1/2004 and we would need a row for 1/1/2000 and 1/1/2001 and 1/1/2002 and 1/1/2004. Anyone know how to do this without an...

We found differences with Crystal running faster than stored procedures alone EVEN with Crystal running the exact same stored procedures. This was with both Oracle and MSSQL. Something to do with how Crystal is launching it. Although we never fully investigated it we suspected network bottlenecks.

DATEADD(MONTH,1,'6/30/99') returns 7/30/99 I want it to return 7/31/99. If the date is 6/15/99 I would want it to return 7/15/99 (which it does). Please, any ideas of what to do here?

We were on a tight deadline, the customer gave me MSSQL 2000 to develop on. Now they say they need all of the procedures / functions etc in MSSQL 7. It has been a while since I developed in 7.0 BUT I am not seeing the capability for creating functions. Is that really true? MSSQL 7.0 did not...

Basically we have some stored procedures being called from C++ code. The procedures gather data and populate tables against which a report will be run. But the C code returns immediately without waiting for the results. Any ideas? Thanks.

Well I got around the problem by doing an if .. begin end Still would like to know why it does not work with if .. then end if

I am doing a simple function with a cursor. I declare the cursor, open the cursor, fetch the cursor. And it compiles fine. I add an if statement right after the fetch and the compiler says error at THEN. I tried different ifs, and different statements within the if. It does not like anything. I...

I need to write some stored procedures against this version of SQL Anywhere. It comes bundled with Sybase Central which has ISQL as an interface (if you can call it that). It is no way of trying to develop complex stored procedures. I tried a couple of ODBC based interfaces (including mySQL and...

Clumsy but you could create a stored procedure that loops looking for the time and then when it gets past a certain time does the update and exits out. Not elegant but it would work.

Sure, I know we can encrypt by saying CREATE PROCEDURE with ENCRYPTION. But what about the file we load from at a customer site. What good is the encrypted procedure if the file we use to create the procedure is not encrypted. Is there an easy way to do this? I tried encrypting and then...

I wrote a series of stored procedures that create tables to be reported against. We have used Crystal reports as an interface. But I am not happy with the way the user has to input parameters and the limitations. Was thinking of doing a VB interface to Crystal. Anyone has some better ideas? I...

You will receive this error in Oracle 8 when the code does a commit during the cursor loop ie the following pseudo code OPEN c_Cursor FETCH c_Cursor INTO v_CurRec While c_Cursor%FOUND LOOP Update where current of c_Cursor COMMIT Fetch will now fail with out of sequence END LOOP

There is a %ROWCOUNT in Oracle to find the number of rows a cursor has fetched. The count can be used to test before the cursor fetches. If no rows are returned the count variable will be NULL.

Sem: Misunderstood. Anyway there is nothing like that in the package body. The function is encapsulated in the same package as the calling procedures. The package body only sets up some private global variables. I did try moving them all to the header, and it made no diff.