Technical Questions: Oracle, Store procedure and custom where

Print Page | Close Window

Oracle, Store procedure and custom where

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12773
Printed Date: 06 May 2024 at 3:02am

Topic: Oracle, Store procedure and custom where

Posted By: litterat
Subject: Oracle, Store procedure and custom where
Date Posted: 31 Mar 2011 at 8:59pm

Hi all

I have a store procedure which check if user can view a record or not

I need to use it in the where clause

something like this

select * from sometable

where sometable.userId = userCanView(sometable.id, sometable.userId)

I could not find a way to do this

Please help

Thanks in advance

Nehemia

Replies:

Posted By: lockwelle
Date Posted: 01 Apr 2011 at 2:20am

get your data via a stored proc, then you can chain/filter on that stored proc.

CR will not connect to database to ask it any questions, other than give me this data. For something like that you need to it during the data retrieveal stage, which to use a stored proc like that would be in a stored proc / view

Print Page | Close Window