Hi diana..

You can use the variable instead of the path in the query..and thats actually intended for dynamic path only..

For error..please debug and print the dynamic SQL getting prepared..and rectify the error..

or if that doesnt solve the problem... send your full query..

Regards,