Click here to Skip to main content
14,976,594 members
Home / Discussions / Database
   

Database

 
AnswerRe: Cannot start MSSQLSERVER Pin
Corporal Agarn18-Aug-11 2:02
professionalCorporal Agarn18-Aug-11 2:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
AnswerRe: Cannot start MSSQLSERVER Pin
Wendelius18-Aug-11 6:26
mveWendelius18-Aug-11 6:26 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 21:38
professionalBlikkies18-Aug-11 21:38 
QuestionOracle Collection Objects Pin
lionelcyril17-Aug-11 21:22
Memberlionelcyril17-Aug-11 21:22 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:10
mveWendelius18-Aug-11 8:10 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:21
Memberlionelcyril18-Aug-11 8:21 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:32
mveWendelius18-Aug-11 8:32 
Ok, well basically when you create a procedure (of any kind) and store it in the database, you modify the schema. So in this sense the requirement of leaving the schema intact doesn't make sense...

Anyhow, you can use collections and for example if you're using a package, you can define the collection in your procedure or at package level. When you loop through the cursor you can store the results in the collection and later on modify them or add more results etc. If you're using package level variables, you can store the results in them even between procedure calls.
The need to optimize rises from a bad design.My articles[^]

GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:37
Memberlionelcyril18-Aug-11 8:37 
GeneralRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:56
mveWendelius18-Aug-11 8:56 
QuestionMax. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 18:55
MemberNavin Pandit17-Aug-11 18:55 
AnswerRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:00
mveWendelius17-Aug-11 19:00 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 19:10
MemberNavin Pandit17-Aug-11 19:10 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:35
mveWendelius17-Aug-11 19:35 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell18-Aug-11 13:02
Memberjschell18-Aug-11 13:02 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit18-Aug-11 18:33
MemberNavin Pandit18-Aug-11 18:33 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell19-Aug-11 7:34
Memberjschell19-Aug-11 7:34 
QuestionSearching with optional parameters [modified] Pin
Pascal Ganaye16-Aug-11 1:36
MemberPascal Ganaye16-Aug-11 1:36 
AnswerRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 3:23
professionalPIEBALDconsult16-Aug-11 3:23 
GeneralRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:16
MemberPascal Ganaye16-Aug-11 4:16 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:21
MemberPascal Ganaye16-Aug-11 4:21 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 17:56
professionalPIEBALDconsult16-Aug-11 17:56 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes16-Aug-11 18:06
professionalMycroft Holmes16-Aug-11 18:06 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 2:48
professionalPIEBALDconsult17-Aug-11 2:48 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes17-Aug-11 5:40
professionalMycroft Holmes17-Aug-11 5:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.