$db= ZendDb::factory('Oracle');
$db->insert('SCHEMA.TABLE', $params);
And I'm getting the 'Table or view does not exist' error. Is this usage
supported by Zend_Db? Or how can I insert using a schema name? The
workaround I'm going to try next is to create a Zend_Db_Table subclass since
it looks like it allows you to specify schema name, but I'd like to avoid
doing that in this case.
Gabriel Baez-2 wrote:
>
> no, but if you want to select data from other schemas you should try
> select * from schemaname.tablename sorry for the late responce.
>
> On Sun, Jun 8, 2008 at 8:27 PM, Jonathan Kushner <jkushner@bluehornet.com>
> wrote:
>
>> If so, can you share how you connect to a particular schema. I cannot
>> locate this info on zend_db documentation.
>>
>>
>>
>> *From:* Jonathan Kushner [mailto:jkushner@bluehornet.com]
>> *Sent:* Sunday, June 08, 2008 6:19 PM
>> *To:* Gabriel Baez
>> *Cc:* fw-db@lists.zend.com
>> *Subject:* RE: [fw-db] Still having oracle schema issues....
>>
>>
>>
>> Are you using multiple schemas?
>>
>>
>>
>> *From:* Gabriel Baez [mailto:sheik316@gmail.com]
>> *Sent:* Sunday, June 08, 2008 5:34 AM
>> *To:* Jonathan Kushner
>> *Cc:* fw-db@lists.zend.com
>> *Subject:* Re: [fw-db] Still having oracle schema issues....
>>
>>
>>
>> I use Oracle and never had a problem with output.
>>
>> On Thu, Jun 5, 2008 at 12:47 AM, Jonathan Kushner
>> <jkushner@bluehornet.com>
>> wrote:
>>
>> Just wanted to add… I didn't mean the annoying part. I probably could
>> just
>> as easily do a diff on the connection, and extend off zend oracle… I just
>> would rather not do that right this second.
>>
>>
>>
>> Sorry about that.
>>
>>
>>
>> -Jonathan
>>
>>
>>
>> *From:* Jonathan Kushner [mailto:jkushner@bluehornet.com]
>> *Sent:* Wednesday, June 04, 2008 8:29 PM
>> *To:* fw-db@lists.zend.com
>> *Subject:* [fw-db] Still having oracle schema issues....
>>
>>
>>
>> Hi. I am not getting the same output from Zend_Db_Oracle as I do with my
>> $db object. If this seems to be a problem, then I would like to know if
>> it
>> is possible for me to use the profiler on my own db oracle object. I was
>> thinking today that I would probably just extend my object off
>> oracle_adapter to make it zend_interface profiling compliant. Can you
>> guys
>> please help, because this is getting annoying already. If you would like
>> any
>> specific information, please let me know and I will do my best to get you
>> what you need.
>>
>>
>>
>>
>>
>> Thank you,
>>
>>
>>
>>
>>
>> Jonathan
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Still-having-oracle-schema-issues....-tp17661416p19059554.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论